delete data from table without rollback/logging?

From: Steve Salvemini <steve.salvemini_at_adelaide.edu.au>
Date: Fri, 05 Oct 2001 11:50:59 +0930
Message-ID: <3BBD190B.D3B36442_at_adelaide.edu.au>

[Quoted] [Quoted] Hi group, I'm running a cut down script on a copy of a live database to remove some 90%
of the data.

[Quoted] [Quoted] Currently I use delete statements to remove the data from 100's of tables.
[Quoted] Another method I can use is to copy out 10% into a temp table, truncate the original and
then copy the 10% back in, reducing the hit on the rollback segments.

[Quoted] Regardless of which option I take, is there a faster option to delete and insert data without filling up the rollback segments.

[Quoted] I see 'alter table xxx nologging' doesn't seem to be affected by deletes.

[Quoted] Ideally an 'alter session nologging' statement would be useful.

[Quoted] Also, I would have dedicated use of this database, if that helps with any ideas.

Cheers

Steve Received on Fri Oct 05 2001 - 04:20:59 CEST