Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Deletion Of 160 Million Rows.
make sure you submit the code to
http://www.rube-goldberg.com/
> I would use combo of following:
> Bulk collect - limit 100 - 500
> Use index org table to hold row'ids populated from live table.
> commit batches
> sleep every second between batches.
> --
> ..
> David
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 08 2005 - 14:11:17 CST