1. COPY command in SQL*Plus:
SQL> COPY FROM SCOTT/TIGER@HQ TO JOHN/CHROME@WEST CREATE EMP USING SELECT * FROM EMP

Default commit takes place at end of succesfull commit. With large tables set SQL*Plus variable COPYCOMMIT to positive value.


2. With database link.
With database link hq on database west:
CREATE TABLE emp AS SELECT * FROM emp@hq;