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