I have been handed a couple of requests to change some data. One is an update on 3.6 million records and the other is two different deletions of over 16 million rows of data. I need to be able to do these in batches as I am told that Oracle will "blow up" if I do them in one shot.
I would like to do them in increments of 50,000 then a commit...then the next 50,000 and then another commit. What it is the best way to do this? Robert
