Copy table from one database to another

Copy table from one database to another

Login as SYS

SQL> copy from scott/tiger@orcl to exam2/exam2@orcl create new_emp using select * from emp where 1=2;

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)
Table NEW_EMP created.

   0 rows selected from scott@orcl.
   0 rows inserted into NEW_EMP.
   0 rows committed into NEW_EMP at exam2@orcl.

SQL>