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

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

Other related posts: