-
Problem setting transaction to a rollback segment
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|