-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|