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
Received on Wed Aug 31 2005 - 23:53:38 CDT
