Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Deletion Of 160 Million Rows.

Re: Deletion Of 160 Million Rows.

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 8 Feb 2005 14:06:31 -0500
Message-ID: <BAY20-DAV15C03B4778EDD993D725E8A6740@phx.gbl>


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-l
Received on Tue Feb 08 2005 - 14:11:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US