Re: Deletion Of 160 Million Rows.
- From: "David" <thump@xxxxxxxxxxxxxxxx>
- To: sheldonquinny@xxxxxxxxx
- Date: Tue, 8 Feb 2005 10:37:11 -0800 (PST)
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
> Anyways IF U Guys Have Something Diffrent From The Above Solutions ,
> Would Be Nice To Share.. If Not, I Shall Work On The Given Soution
> With The Seniors.
> Thank You.
> Sheldon
--
//www.freelists.org/webpage/oracle-l
Other related posts:
