Hello All,
I am a new for Oracle. I am looking for the best way to transfer data (table to table) from one Oracle database on Unix box to other Oracle server on NT server.
Any input at all here would be appreciated.
Stella Liu
Printable View
Hello All,
I am a new for Oracle. I am looking for the best way to transfer data (table to table) from one Oracle database on Unix box to other Oracle server on NT server.
Any input at all here would be appreciated.
Stella Liu
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;
Export/Import would do this task too or even better.