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;