Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Distributed databases and rollback segments
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