| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DELETE FROM table UNRECOVERABLE?
Would you know if DELETE UNRECOVERABLE is a valid statement in other
databases, such as DB2 or
SQL Server? Since the code is generic in nature in order to support
portability, I wonder if=20
perhaps this code originated from another database. The users said
this was to be a truncate=20
and load operation and I don't believe for a minute that UNRECOVERABLE
is intended to be an=20
alias.
And, we can't remove the UNRECOVERABLE, it's code belonging to a purchased module.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jacques Kilchoer
Sent: Thursday, May 20, 2004 4:49 PM
To: oracle-l_at_freelists.org
Subject: RE: DELETE FROM table UNRECOVERABLE?
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. =3D20
-----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=3D20 have any impact on the HWM.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |