RE: Fav. Urban Legend...take two

From: Freeman, Robert <Robert_Freeman_at_csx.com>
Date: Thu, 14 Mar 2002 12:20:29 -0800
Message-ID: <F001.00429E7B.20020314122029@fatcity.com>

Last time I read the doc's this was true... (and that was about a second ago!).
is there some magic I do not know about? (or are you alluding to creating PL/SQL
to do this?)

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

-----Original Message-----
Sent: Thursday, March 14, 2002 2:36 PM
To: Multiple recipients of list ORACLE-L

Whoa, #3 is a new one on me! What privs do allow that one?

-----Original Message-----
Sent: Thursday, March 14, 2002 12:57 PM
To: Multiple recipients of list ORACLE-L

#3 One has to have 'delete any table' privilege to truncate someone else's tables.

#2 Oracle does not write to the data file when the tablespace is in backup mode.

And...

#1 High Cache Hit Ratios (in the upper 90s) are always good.

• Kirti
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Post, Ethan INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Freeman, Robert
  INET: Robert_Freeman_at_csx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 14 2002 - 14:20:29 CST