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

Thread: Immigrate Data

  1. #1
    Join Date
    Aug 2000
    Hi , Friends ,
    I'm now thinking a solution to immigrate the data .

    The situation is :
    Server A : NT , Oracle7.3 . User1 has table T1,T2,T3
    Server B : NT , Oracle7.3 . User1 has table T1,T2,T3
    (the table name is same and the table structure is also
    simular , but in ServerB , the table has some additional columns ) .

    Now we want to clone all the data from ServerA , User1 to
    ServerB User1 . The data valumn is very big (1million records
    in some table and around 1 GB data in User1 ) . Because of the table struture is different , So import and export seems not working.

    Please advise .



  2. #2
    Join Date
    Oct 2001
    You can create DB Link in server 2 which link with server 1. In server 2 you can write sql like this: INSERT INTO T1(column1,column2....) SELECT column1,column2.... FROM T1@dblink, instead of exp/imp.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.