RE: DELETE FROM table UNRECOVERABLE?
- From: "Thomas Jeff" <jeff.thomas@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 May 2004 07:48:18 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jacques Kilchoer
Sent: Thursday, May 20, 2004 4:49 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Jeff
Sent: jeudi, 20. mai 2004 13:27
To: oracle-l@xxxxxxxxxxxxx
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
