Re: Fav. Urban Legend...take two
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
but those bugs are not accessible on MetaLink. 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
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).
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).
Re: Fav. Urban Legend...take two
[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
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
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
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
From the Oracle9i docs@ http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/st atements_108a.htm#2067573 http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/s 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).
RE: Fav. Urban Legend...take two
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
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
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
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 http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/s 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
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
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 http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/s 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
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 http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/s 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). -- 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
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
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
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
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).