Re: advice for massive delete querry

John Clarke wrote:

I'm with Mark - create a scratch table (nologging of course, PCTAS maybe)
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.


All this effort for measly 150M? Increasing buffer pool, making sure that there is enough undo and disabling indexes should do the trick.
With parallel DML, it would probably be gone in a hour.

--
Mladen Gogala
Oracle DBA
Ext. 121

--
http://www.freelists.org/webpage/oracle-l

Other related posts: