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
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
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
#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,
[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.
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
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
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
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
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-
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
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
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@
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
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:
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
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
---
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
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
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
20 matches
Mail list logo
