SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jun 2009
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Copying 1 db to another db

    hi,
    i am working in oracle 10g. i have two servers with different DB. but the tables of two db are same. i want to copy the db of 1 server to db of 2nd server such that to append only those rows and column of tables of server 2 which are not in database of server 1.
    how can i do this.

  2. #2
    SitePoint Enthusiast LewisClarkTrail's Avatar
    Join Date
    Jun 2009
    Location
    U.S.
    Posts
    37
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Do you mean to say that you want to insert rows from table 2 where there is no row in table 1 with the same key value, and when there is a row in table 1 with the same key value then you want to update the row in table 1 so that it is identical to the one in table 2?

    In that case look up the MERGE statement in the Oracle® Database SQL Language Reference.


Bookmarks

Posting Permissions

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