Re: COPY command in PL/SQL

>
> COPY is a sql*plus command not a sql command.
>
> If don't have longs in your table you could use
> just as well
> insert into <table>_at_database
> select * from <table>
>
> Tbis will be slower though.
>
> Hth
> Sybrand Bakker
> Senior Oracle DBA

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?

Thanks, Steve Received on Wed Oct 31 2001 - 00:34:58 CET