You can use copy just reference the same tnsnames.ora entry.
Here is the documentation location: http://download-west.oracle.com/docs...apb.htm#634246


Here is the example in the documentation:

COPY FROM HR/your_password@BOSTONDB -
TO HR/your_password@BOSTONDB -
INSERT EMPLOYEE_COPY2 -
USING SELECT * FROM EMPLOYEE_COPY

I have done this is the past just be careful to run initial test on a smaller set of data before going for a larger set. Also the dashes are necessary to indicate next line.