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

Thread: oracle replication

  1. #1
    Join Date
    Jul 2003
    Location
    India
    Posts
    5

    oracle replication

    hi members,
    i am having two different database in two location . i want to replicate 150 tables. i am trying to use master to master replciation. The new data is replicating both the places. But the updation and unique conflict is not happening properly. I am using site priority for updation.
    please help me to solve this problem

    thanks
    sudheesh

  2. #2
    Join Date
    May 2001
    Posts
    736
    Did u take that the columns on which the update conflicts are key columns.I did this type of conflict on primary key columns and they do work.

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    is it a topic on snapshoot or oracle advanced replication?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Originally posted by ligang
    is it a topic on snapshoot or oracle advanced replication?
    sudheesh wrote: master to master replication.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  5. #5
    Join Date
    Apr 2002
    Location
    Bangalore
    Posts
    47

    Thumbs up

    Hi when you are using multi master replication you need to use primary keys or rowid for conflict resolution.
    Cheers
    Murali

  6. #6
    Join Date
    Apr 2002
    Posts
    28
    sudheesh,

    You may have your conflict resolution configured incorrectly for this situation. Here are some example scripts which I think may help with this setup:

    http://www.dotcomsolutionsinc.net/pr...gen_files.html

    David Simpson
    http://www.dotcomsolutionsinc.net

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