Copy data from one database to another

Copy Command:

SQL> COPY FROM apps/xxxx@uat TO apps/xxxx@prod INSERT XXHR_EMP_DOJ USING SELECT * FROM XXHR_EMP_DOJ;