Steven Lembark wrote:
-- Robert Hicks <[EMAIL PROTECTED]>
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.
The issue is rollback/redo space. If you have too large
of a transaction pending you can run out of space and
it abort the transaction. You may have sufficient space
to blow off this many records, but it'll be a True Pain
to find out the hard way...
The limit...10,000 and he had to increase the rollback space or some
such to get it to work right.
Robert
