RE: Fav. Urban Legend...take two

[Freeman, Robert]

<>

ALways seems like the bugs I go looking for end up having
base bugs which are not publicly accessible on Metalink...

What I find really funny is that once in a while in the bug
reports that are publicly available, you will find the contact
(customer) name and phone number... and sometimes you will
find the phone number of the developer working on the bug.
I haven't had the heart to call any of those that I've seen
yet and tell them

RF

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.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...take two

[Jared Still]

Yes, I've seen that also.

Bugs   299259 and BUG:207590 describe this change in
behavior, and why it was done, but those bugs are not
accessible on MetaLink.

Jared


On Thursday 14 March 2002 15:03, Jonathan Lewis wrote:
> I hate to perpetuate a legend, but I THINK there
> was an early version where 'delete any table'
> was good enough.  I seem to remember a period
> where there was a big fuss from people saying
> "I've upgraded to version 7.0.16-ish and my truncates
> are not longer working"  -  and the problem was that
> they had granted 'delete any table' and the upgrade
> required 'drop any table'.
>
>
> I also have a vague memory of seeing a release note
> (readme.doc) which highlighted this issue.
>
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar - UK, April 3rd - 5th
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: 14 March 2002 21:26
>
> |the docs are (finally) correct.
> |
> |you have ALWAYS needed "drop any table" to truncate someone else's
> |table. The docs have always said you needed "delete any table". Docs
> |(horrors! impossible to believe!) were wrong
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...take two

[Jonathan Lewis]

I hate to perpetuate a legend, but I THINK there
was an early version where 'delete any table'
was good enough.  I seem to remember a period
where there was a big fuss from people saying
"I've upgraded to version 7.0.16-ish and my truncates
are not longer working"  -  and the problem was that
they had granted 'delete any table' and the upgrade
required 'drop any table'.


I also have a vague memory of seeing a release note
(readme.doc) which highlighted this issue.


Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 14 March 2002 21:26


|the docs are (finally) correct.
|
|you have ALWAYS needed "drop any table" to truncate someone else's
|table. The docs have always said you needed "delete any table". Docs
|(horrors! impossible to believe!) were wrong
|



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[John Kanagaraj]

Some more from me! (if they have already not been stated)

"The 'alter database backup controlfile' creates a backup of the controlfile
that is used in 'recover database using backup controlfile'"

"Backup the controlfiles"

"using 'shutdown abort' to stop the database damages it beyond repair"

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> -Original Message-
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 14, 2002 10:57 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Fav. Urban Legend...take two
> 
> 
> #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 
> 
> -Original Message-
> Sent: Thursday, March 14, 2002 12:21 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Ok... one of my favorite Urban Legends is this one:
> 
> The book is always right. In other words, if it's written down
> in a book we bought off of Amazon, it must be so.
> 
> So, I'd like to ask, without anyone taking potshots at
> specific authors, what is the dumbest, silliest, or most
> technically incorrect thing you have ever seen in an 
> Oracle book?
> 
> RF
> 
> 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.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Freeman, Robert 
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: John Kanagaraj
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...take two

[Rachel Carmichael]

that one's been around for years! Jeremiah has corrected, and corrected
and corrected it, but it persists

just like those baby alligators in the NYC sewer system rumors...


--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> Holy cow.  That is outrageous!  Gets my vote.
> 
> 
> --- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> > Gotta be this one.  I wouldn't love it so much except for the part
> > about the USS Nimitz.
> > 
> > > When you place a tablespace in backup mode, the Oracle instance
> > > notes that a backup is being performed and internally compensates
> > > for it. As you know, it is impossible to make an authentic copy
> of
> > a
> > > database file that is being written to. On receipt of the command
> > to
> > > begin the backup, however, Oracle ceases to make direct changes
> to
> > > the database file. It uses a complex combination of rollback
> > > segments, buffers, redo logs, and archive logs to store the data
> > > until the end backup command is received and the database files
> are
> > > brought back in sync.
> > > 
> > > Simplifying a hot backup in this way is tantamount to classifying
> > > the USS Nimitz as a boat. The complexity of the actions taken by
> > the
> > > Oracle RDBMS under a hot backup could consume an entire chapter
> and
> > > is beyond the scope of this book. What you should understand is
> the
> > > trade-off for taking a hot backup is increased use of rollback
> > > segments, redo logs, archive logs, and internal buffer areas
> within
> > > the SGA.
> > 
> > --
> > Jeremiah Wilton
> > http://www.speakeasy.net/~jwilton
> > 
> > On Thu, 14 Mar 2002, Freeman, Robert wrote:
> > 
> > > Ok... one of my favorite Urban Legends is this one:
> > > 
> > > The book is always right. In other words, if it's written down
> > > in a book we bought off of Amazon, it must be so.
> > > 
> > > So, I'd like to ask, without anyone taking potshots at
> > > specific authors, what is the dumbest, silliest, or most
> > > technically incorrect thing you have ever seen in an 
> > > Oracle book?
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Jeremiah Wilton
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [EMAIL PROTECTED] (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).
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Sports - live college hoops coverage
> http://sports.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...take two

[Jared Still]

Funny, I was just told that by a Network Appliance rep today.

Had to set him straight.  :)

I hate doing that.  ;)

Jared

On Thursday 14 March 2002 12:42, Rachel Carmichael wrote:
> it's still the one about Oracle not writing to the datafiles if a
> tablespace is in hot backup mode :0
>
> --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> > Ok... one of my favorite Urban Legends is this one:
> >
> > The book is always right. In other words, if it's written down
> > in a book we bought off of Amazon, it must be so.
> >
> > So, I'd like to ask, without anyone taking potshots at
> > specific authors, what is the dumbest, silliest, or most
> > technically incorrect thing you have ever seen in an
> > Oracle book?
> >
> > RF
> >
> > 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.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Freeman, Robert
> >   INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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).
>
> __
> Do You Yahoo!?
> Yahoo! Sports - live college hoops coverage
> http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Freeman, Robert]

One of these days my eyes will distinguish the word DROP and the word
DELETE...
For now, just chalk it up to age :-))

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 3:21 PM
To: Multiple recipients of list ORACLE-L


>From the Oracle9i docs@ 
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/st
atements_108a.htm#2067573
 
 
Under TRUNCATE
To truncate a table or cluster, the table or cluster must be in your schema
or you must have DROP ANY TABLE system privilege. 
 
Is this a documentation bug?
 

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:49 PM
To: Multiple recipients of list ORACLE-L


It's a DDL command.  You need alter table for this.  Delete any table in a
DML privilege. 

Rodd 

On Thu, 2002-03-14 at 13:35, Post, Ethan wrote: 

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: [EMAIL PROTECTED]



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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Freeman, Robert]

Ok, I understand what you were saying then... thanks!

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 4:16 PM
To: Multiple recipients of list ORACLE-L


the docs are (finally) correct.

you have ALWAYS needed "drop any table" to truncate someone else's
table. The docs have always said you needed "delete any table". Docs
(horrors! impossible to believe!) were wrong


--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> From the Oracle9i docs@ 
>
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/st
> atements_108a.htm#2067573
>
 tatements_108a.htm#2067573> 
>  
> Under TRUNCATE
> To truncate a table or cluster, the table or cluster must be in your
> schema
> or you must have DROP ANY TABLE system privilege. 
>  
> Is this a documentation bug?
>  
> 
> 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:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> It's a DDL command.  You need alter table for this.  Delete any table
> in a
> DML privilege. 
> 
> Rodd 
> 
> On Thu, 2002-03-14 at 13:35, Post, Ethan wrote: 
> 
> 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: [EMAIL PROTECTED]
> 
> 
> 
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...take two

[Paul Baumgartel]

Holy cow.  That is outrageous!  Gets my vote.


--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> Gotta be this one.  I wouldn't love it so much except for the part
> about the USS Nimitz.
> 
> > When you place a tablespace in backup mode, the Oracle instance
> > notes that a backup is being performed and internally compensates
> > for it. As you know, it is impossible to make an authentic copy of
> a
> > database file that is being written to. On receipt of the command
> to
> > begin the backup, however, Oracle ceases to make direct changes to
> > the database file. It uses a complex combination of rollback
> > segments, buffers, redo logs, and archive logs to store the data
> > until the end backup command is received and the database files are
> > brought back in sync.
> > 
> > Simplifying a hot backup in this way is tantamount to classifying
> > the USS Nimitz as a boat. The complexity of the actions taken by
> the
> > Oracle RDBMS under a hot backup could consume an entire chapter and
> > is beyond the scope of this book. What you should understand is the
> > trade-off for taking a hot backup is increased use of rollback
> > segments, redo logs, archive logs, and internal buffer areas within
> > the SGA.
> 
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> On Thu, 14 Mar 2002, Freeman, Robert wrote:
> 
> > Ok... one of my favorite Urban Legends is this one:
> > 
> > The book is always right. In other words, if it's written down
> > in a book we bought off of Amazon, it must be so.
> > 
> > So, I'd like to ask, without anyone taking potshots at
> > specific authors, what is the dumbest, silliest, or most
> > technically incorrect thing you have ever seen in an 
> > Oracle book?
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jeremiah Wilton
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Rachel Carmichael]

the docs are (finally) correct.

you have ALWAYS needed "drop any table" to truncate someone else's
table. The docs have always said you needed "delete any table". Docs
(horrors! impossible to believe!) were wrong


--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> From the Oracle9i docs@ 
>
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/st
> atements_108a.htm#2067573
>
 tatements_108a.htm#2067573> 
>  
> Under TRUNCATE
> To truncate a table or cluster, the table or cluster must be in your
> schema
> or you must have DROP ANY TABLE system privilege. 
>  
> Is this a documentation bug?
>  
> 
> 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:49 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> It's a DDL command.  You need alter table for this.  Delete any table
> in a
> DML privilege. 
> 
> Rodd 
> 
> On Thu, 2002-03-14 at 13:35, Post, Ethan wrote: 
> 
> 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: [EMAIL PROTECTED]
> 
> 
> 
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Freeman, Robert]

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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...take two

[Rachel Carmichael]

it's still the one about Oracle not writing to the datafiles if a
tablespace is in hot backup mode :0


--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> Ok... one of my favorite Urban Legends is this one:
> 
> The book is always right. In other words, if it's written down
> in a book we bought off of Amazon, it must be so.
> 
> So, I'd like to ask, without anyone taking potshots at
> specific authors, what is the dumbest, silliest, or most
> technically incorrect thing you have ever seen in an 
> Oracle book?
> 
> RF
> 
> 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.
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Freeman, Robert 
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Deshpande, Kirti]

drop any table

One of the oldest bugs in Oracle Docs :) Finally got fixed in 8.1.7 Docs. 

- Kirti

-Original Message-
Sent: Thursday, March 14, 2002 1: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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Freeman, Robert]

>From the Oracle9i docs@ 
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/st
atements_108a.htm#2067573
 
 
Under TRUNCATE
To truncate a table or cluster, the table or cluster must be in your schema
or you must have DROP ANY TABLE system privilege. 
 
Is this a documentation bug?
 

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:49 PM
To: Multiple recipients of list ORACLE-L


It's a DDL command.  You need alter table for this.  Delete any table in a
DML privilege. 

Rodd 

On Thu, 2002-03-14 at 13:35, Post, Ethan wrote: 

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: [EMAIL PROTECTED]



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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Rodd Holman]

It's a DDL command.  You need alter table for this.  Delete any table in a DML privilege.



Rodd



On Thu, 2002-03-14 at 13:35, Post, Ethan wrote:

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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Post, Ethan]

You had to unleash that one on us.

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


Gotta be this one.  I wouldn't love it so much except for the part
about the USS Nimitz.

> When you place a tablespace in backup mode, the Oracle instance
> notes that a backup is being performed and internally compensates
> for it. As you know, it is impossible to make an authentic copy of a
> database file that is being written to. On receipt of the command to
> begin the backup, however, Oracle ceases to make direct changes to
> the database file. It uses a complex combination of rollback
> segments, buffers, redo logs, and archive logs to store the data
> until the end backup command is received and the database files are
> brought back in sync.
> 
> Simplifying a hot backup in this way is tantamount to classifying
> the USS Nimitz as a boat. The complexity of the actions taken by the
> Oracle RDBMS under a hot backup could consume an entire chapter and
> is beyond the scope of this book. What you should understand is the
> trade-off for taking a hot backup is increased use of rollback
> segments, redo logs, archive logs, and internal buffer areas within
> the SGA.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Post, Ethan
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Post, Ethan]

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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...take two

[bill thater]

[EMAIL PROTECTED] wrote:

>
>So, I'd like to ask, without anyone taking potshots at
>specific authors, what is the dumbest, silliest, or most
>technically incorrect thing you have ever seen in an 
>Oracle book?
>
if you have a hit ratio of less than 90%, your database is in desperate 
need of tuning.


-- 
--
Bill "Shrek" Thater  ORACLE DBA
[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

A journey of a thousand miles starts with a single step.   - Chinese Proverb 






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...take two

[Deshpande, Kirti]

#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 

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


Ok... one of my favorite Urban Legends is this one:

The book is always right. In other words, if it's written down
in a book we bought off of Amazon, it must be so.

So, I'd like to ask, without anyone taking potshots at
specific authors, what is the dumbest, silliest, or most
technically incorrect thing you have ever seen in an 
Oracle book?

RF

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.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...take two

[Jeremiah Wilton]

Gotta be this one.  I wouldn't love it so much except for the part
about the USS Nimitz.

> When you place a tablespace in backup mode, the Oracle instance
> notes that a backup is being performed and internally compensates
> for it. As you know, it is impossible to make an authentic copy of a
> database file that is being written to. On receipt of the command to
> begin the backup, however, Oracle ceases to make direct changes to
> the database file. It uses a complex combination of rollback
> segments, buffers, redo logs, and archive logs to store the data
> until the end backup command is received and the database files are
> brought back in sync.
> 
> Simplifying a hot backup in this way is tantamount to classifying
> the USS Nimitz as a boat. The complexity of the actions taken by the
> Oracle RDBMS under a hot backup could consume an entire chapter and
> is beyond the scope of this book. What you should understand is the
> trade-off for taking a hot backup is increased use of rollback
> segments, redo logs, archive logs, and internal buffer areas within
> the SGA.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 14 Mar 2002, Freeman, Robert wrote:

> Ok... one of my favorite Urban Legends is this one:
> 
> The book is always right. In other words, if it's written down
> in a book we bought off of Amazon, it must be so.
> 
> So, I'd like to ask, without anyone taking potshots at
> specific authors, what is the dumbest, silliest, or most
> technically incorrect thing you have ever seen in an 
> Oracle book?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Fav. Urban Legend...take two

[Freeman, Robert]

Ok... one of my favorite Urban Legends is this one:

The book is always right. In other words, if it's written down
in a book we bought off of Amazon, it must be so.

So, I'd like to ask, without anyone taking potshots at
specific authors, what is the dumbest, silliest, or most
technically incorrect thing you have ever seen in an 
Oracle book?

RF

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.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).