Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> delete data from table without rollback/logging?
Hi group, I'm running a cut down script on a copy of a live database to
remove some 90%
of the data.
Currently I use delete statements to remove the data from 100's of
tables.
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.
Regardless of which option I take, is there a faster option to delete and insert data without filling up the rollback segments.
I see 'alter table xxx nologging' doesn't seem to be affected by deletes.
Ideally an 'alter session nologging' statement would be useful.
Also, I would have dedicated use of this database, if that helps with any ideas.
Cheers
Steve Received on Thu Oct 04 2001 - 21:20:59 CDT
![]() |
![]() |