You do not need COPY command if you have link.
from db1:
create table_xyz as select **columns to be selected** from table_at_db2@dblink_db2 **your where criteria** ;
This should be enough.
|
Results 1 to 9 of 9
Thread: Copy a tableThreaded View
|
Click Here to Expand Forum to Full Width |