Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Delete without rollback
Could some on please help me with.
I need to delete 100000 rows from a very large table in a SQL*Plus session.
Is there a way to disable the rollback feature so that the delete will be faster.
I am looking for something similar to UNRECOVERABLE in
"create table test1 UNRECOVERABLE as
select * from test"
Thanks Received on Sat May 16 1998 - 17:53:56 CDT