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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
