Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving data between systems
Why not use replication with simple (non-updatable) snapshots ????
Easy to set-up !!!
Regards,
Art Groeneveld
Kenneth C Stahl wrote:
> I have two Unix servers running Oracle 7.3.4. I'll call them Srv1 and
> Srv2. Srv1 is the main repository of data and Srv2 mirrors some of the
> tables. The amount of data is relatively trivial (<10000 rows). The
> tables on Srv2 are truncated nightly in preparation for loading. Both
> systems have tnsnames.ora entries for the other system and the database
> aliases are also Srv1 and Srv2.
>
> I've decided to move the data across the network with simple
> insert/select stements. What I'm wondering is whether there is any
> difference from an efficiency viewpoint between the following:
>
> On Srv1:
>
> INSERT INTO MYTABLE_at_SRV2
> SELECT *
> FROM MYTABLE;
>
> or on Srv2:
>
> INSERT INTO MYTABLE
> SELECT *
> FROM MYTABLE_at_SRV1;
>
> They both accomplish the same purpose, but is one better than the other?
>
> Ken
Received on Fri Jul 16 1999 - 16:00:02 CDT