Re: Deletion Of 160 Million Rows.
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <thump@xxxxxxxxxxxxxxxx>, <sheldonquinny@xxxxxxxxx>
- Date: Tue, 8 Feb 2005 14:06:31 -0500
make sure you submit the code to
http://www.rube-goldberg.com/
----- Original Message -----
From: "David" <thump@xxxxxxxxxxxxxxxx>
To: <sheldonquinny@xxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, February 08, 2005 1:37 PM
Subject: Re: Deletion Of 160 Million Rows.
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
