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

From: P. van der Ven <google_at_pven.tmfweb.nl>
Date: 4 Nov 2002 13:46:47 -0800
Message-ID: <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 Mon Nov 04 2002 - 22:46:47 CET

This message: [ Message body ]
Next message: annabelle: "Beginner, using IF/THEN/ELSE inside a CHECK clause ?"
Previous message: Arnold Selby: "Can not start Apache in 9i Linux"
Next in thread: Chris Leonard: "Re: Difference between "copy from" and "insert .. select""
Reply: Jusung Yang: "Re: Difference between "copy from" and "insert .. select""
Reply: Chris Leonard: "Re: Difference between "copy from" and "insert .. select""

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message