Oracle-L: SET TRANSACTION for a Distributed Transaction

From: Magaliff, Bill <Bill.Magaliff_at_lendware.com>
Date: Tue, 19 Feb 2002 13:19:37 -0800
Message-ID: <F001.0041384A.20020219131937@fatcity.com>

Can I use SET TRANSACTION USE ROLLBACK SEGMENT <RBS_NAME> for a distributed transaction, where I"m doing a whole bunch of INSERTS on a target db that SELECT data from a source db?

I was thinking of constructing this to run when logged into the source db - I'd insert data to a target db across a database link. I assume the RBS would have to be on the target db? Or could the RBS be on the source db, even though the inserts are taking place on the target?

Alternatively I could write the script whereby the inserts happen on the local db and the selects happen across the db link - in that case the SET TRANSACTION would use a local RBS . . .

any ideas/comments on writing putting something like this together?

Thanks

-bill magaliff
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Magaliff, Bill
INET: Bill.Magaliff_at_lendware.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 19 2002 - 15:19:37 CST