Yes, Shelley, you can assign a specific rollback segment for any transaction (regardless of what you plan on doing in the transaction) with the following code:
Code:
commit;
Set transaction use rollback segment <rbs-name>;
the "commit" prior to the set is just to ensure that your "set transaction" statement is the first statement in the transaction.
Let us know if this produces the effect that you wanted.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.