John Clarke wrote:
I'm with Mark - create a scratch table (nologging of course, PCTAS maybe)All this effort for measly 150M? Increasing buffer pool, making sure that there is enough undo and disabling indexes should do the trick.
with all the data you want to keep, truncate the original table, and
direct-path insert rows from the scratch table back into the original. Drop
the scratch table when done.
-- Mladen Gogala Oracle DBA Ext. 121
-- //www.freelists.org/webpage/oracle-l