Re: Difference between "copy from" and "insert .. select"

"COPY" is mainly designed for copying data between ORACLE and non-ORACLE databases, and will be obsoleted in the future. As to performance, why not create a big dummy table and try it out for yourself?

• Jusung Yang

google_at_pven.tmfweb.nl (P. van der Ven) wrote in message news:<39bfb0cd.0211041346.2b667fae_at_posting.google.com>...
> Hi!
>
> I am trying to find out the differences between the "copy
> from"-command (CF) and the "insert ... select"-command (IS).
>
> Until now I have only found out one difference: when you copy from dbA
> to dbB using CF in SQL*plus on your own PC the data will go from dbA
> through your SQL*plus-session to dbB. When using IS you can copy
> directly from dbA to dbB.
>
> What is the advantage of CF or IS? (I am very interested in the
> performance.)
>
> Regards,
> P. van der Ven
Received on Tue Nov 05 2002 - 18:08:54 CET