Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete without Rollback ?
yuri_at_iee.org wrote in article <6qcbhj$f4t$1_at_nnrp1.dejanews.com>...
> In article <35C85724.CCE4EA38_at_a.com>,
> John Finn <a_at_a.com> wrote:
>
> > Does anyone know how to Delete without Rollback transaction overhead?
> > "DELETE FROM TABLE1 WHERE ..."
> > and no transaction overhead, rollback, commit ...
>
> If you want to get rid of all the data, use "TRUNCATE". If (as I
suspect) you
> want to use a "WHERE" clause on a very large table, it may be worth doing
the
> following...
>
> SQL> CREATE TABLE TEMP_COPY UNRECOVERABLE AS SELECT * FROM TABLE1
WHERE...
> SQL> DROP TABLE TEMP_COPY;
> SQL> RENAME TEMP_COPY TO TABLE1;
??? Shouldn't the second one be:
SQL> DROP TABLE TABLE1;
Otherwise you are dropping the table you just created?
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
Received on Thu Aug 06 1998 - 13:08:05 CDT