Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Specify a rollback segment to use in a remote database

Specify a rollback segment to use in a remote database

From: Tansel Ozkan <tansel_at_openix.com>
Date: Wed, 27 Jan 1999 17:10:45 -0500
Message-ID: <78o3ou$1n4@enews4.newsguy.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US