Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Copy tables to another database

    I want to copy tables from one database to another *using query*. Note that the other database can be local or remote.

    I know how to do this using COPY command.

    1. I don't know much about database link. Can this be done using database link? How?
    2. Would database link method be faster than COPY command.


  2. #2
    Join Date
    Apr 2003
    Greenville, SC (USA)
    You will have to have a database link between the 2 databases in question.

    You can then use:
    create table tablename as select * from

    ... This is a nologging event so it is pretty quick ... depending on the size of the table you are copying and the amount of data to pull thru the link.

    You could also use exp/imp from database to database


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts