Re: Moving data between systems

Hi,

  I have not tested the scenario you mentioned. But you could use the COPY command to accomplish the same result. That should be faster.

Regards,
Denny

In article <378DF1BA.C83410CD_at_Unforgettable.com>,   BluesSax_at_Unforgettable.com 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
>
>

--
Denny Koovakattu
denny_at_vitalsol.com
http://vitalsol.com/

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 15 1999 - 10:55:18 CDT