Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2012
    Posts
    37

    Unanswered: How to Sync two schemas with help of procedure in ORACLE

    Hi

    I have two different databse name odev and edev
    There is DB link setup from edev to odev or I can say that when i am present in edev database i can access the tables of
    odev with the help of DB link. The name of the DB link is scr

    The tables present in the odev database are
    A1
    B1
    X1
    Y1

    The tables present in the edev database are
    A1
    B1
    X1
    Y1

    Means to say that the same table and structure are present in two different database database
    Is it possible to write the procedure in edev database to sync the talbe present in edev by odev

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is it possible to write the procedure in edev database to sync the talbe present in edev by odev
    YES

    post SQL & results that show rows that are "in synch" between the two tables.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2012
    Posts
    37
    Actually i am new so looking for how to start..

  4. #4
    Join Date
    Mar 2012
    Posts
    37
    what i thought is to develop the cursor which will hold the table name then i should make one temp table and populate the data...After that i should delete the records of the table and the populate it with different database table

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Actually i am new so looking for how to start..
    It is not possible to start writing code when you don't know column_names & requirements to be met.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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