Re: COPY command in PL/SQL

stevenmgarcia_at_hotmail.com (Steve) wrote in message news:<4c049a8c.0110301534.8136646_at_posting.google.com>...

> Any recommendations on how to copy data from several tables from one
> database to another? This is what I need to do, and I would like to
> use the copy command because it is more efficient than "insert into
> table select from"
>
> Is there anyway to loop through the copy command?

I haven't tried any tests with it yet, but you might be able to combine the 'insert into' with bulk binds. This might be more efficient.

-Steve F. Received on Wed Oct 31 2001 - 23:16:08 CET