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 -> Distributed databases and rollback segments

Distributed databases and rollback segments

From: Scott <sjohnson_at_ibm.net>
Date: 1997/04/25
Message-ID: <3361522E.29D3@ibm.net>#1/1

I am attempting to move a large amount
of data from a database to as second database through a database link. If the command:

insert into table1_at_DB
select * from tmcaddr;

what rollback segment is used? the local rollback or the rollback on the receiving database. If its the rollback on the distributed database, can this rollback be specified?
Such as: set transaction use rollback segment r10_at_DB

I don't think the above is legal but you get the idea.

Thanks,
Scott
sjohnson_at_ibm.net Received on Fri Apr 25 1997 - 00:00:00 CDT

Original text of this message

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