Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Specify a rollback segment to use in a remote database
Hello all,
I have a procedure that updates a table in a remote database. However, when I run it, I am getting the max rollback segments reached error message. So, my question is: Is there a way to specify which rollback segment to use before a distributued update statement similar to doing it locally as follows:
SET TRANSACTION USE ROLLBACK SEGMENT big_rollback;
Thanks..
Tansel Received on Wed Jan 27 1999 - 16:10:45 CST