Hi

I have a problem with a script that I am trying to run that will update millions of rows.

In order to offset the chance of blowing out the rollback segments, I created a very large public rollback segment, set the transaction to use it, and then started the script.

However, it uses all of the other rollback segments, and then when it runs out of rollback segments, it fails.

Is there anyway around this? I have never had this particular problem setting a specific rollback segment to a specific transaction.

Thanks