Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Delete without rollback

Delete without rollback

From: x <x_at_x.com>
Date: Sat, 16 May 1998 15:53:56 -0700
Message-ID: <355E1903.28A0@worldnet.att.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US