DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Copy Data?

  1. #1
    Join Date
    Oct 2000
    Posts
    5

    Question

    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

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    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;

  3. #3
    Join Date
    Jul 2000
    Posts
    6
    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
  •  


Click Here to Expand Forum to Full Width