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

> 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

--
http://www.freelists.org/webpage/oracle-l

Other related posts: