RE: DELETE FROM table UNRECOVERABLE?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 20 May 2004 14:48:31 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262119FC1B@irvmbxw02>

Unrecoverable was used in Oracle 7.3.4 in a Create Table As Select command to have the create statement behave as NOLOGGING does in Oracle 8.0 and later. In versions after 7.3.4 the UNRECOVERABLE option was still allowed on the CREATE TABLE AS SELECT ... Statement but it was deprecated and the manual said to use NOLOGGING instead. The UNRECOVERABLE clause did not exist for the DELETE command (the "keyword" must be being treated as an alias for the table), and the current NOLOGGING table attribute does not apply to UPDATE or DELETE. So you could just remove the UNRECOVERABLE from the statement. =20

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Jeff Sent: jeudi, 20. mai 2004 13:27
To: oracle-l_at_freelists.org
Subject: DELETE FROM table UNRECOVERABLE?

I'm seeing this statement being issued in one database. I cannot find the
UNRECOVERABLE keyword in the 9i SQL Reference. Is UNRECOVERABLE perhaps
an old keyword that is now ignored by Oracle? I did some quick testing with AUTOTRACE, and noted no difference for the values for Redo Size as compared to a DELETE w/o UNRECOVERABLE, nor did it=20
have any impact on the HWM.

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu May 20 2004 - 16:45:36 CDT