Re: Distributed databases and rollback segments

In article <3361522E.29D3_at_ibm.net>, Scott <sjohnson_at_ibm.net> wrote:
>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

Scott,

You don't specify what version of Oracle you are running but if you are running 7.2 or later try

create table derf
as unrecoverable
select * from fred

This will not need rollback segments

Hope this helps

mjr Received on Mon Apr 28 1997 - 00:00:00 CDT