Q

Conflict resolution in two-way replication

I am using two-way replication (updateable snapshot) but am unable to solve an add/update conflict. I already have

gone through the manual but have been unable to implement the confilict resolution method. Can you please provide some example or document which shows a conflict resolution method?

Which version(s) of Oracle are you using in both databases? This might make a difference in what you are doing.

By two-way replication, I'm going to assume that you mean that if a table gets updated in DB_A that change will propogate to the replicated table in DB_B. And that a change in that same table in DB_B will result in a change to the similar table in DB_A. This is a very tricky scenario. If I insert a record into DB_A, then that record gets inserted into DB_B too by replication. But this record is now inserted into DB_B so two-way replication will insert this back into DB_A again. This process could repeat itself indefinitely.

I've never seen this in practice myself. Normally, the replication is one-way with one database serving as the master and the other(s) as a slave. If I did have the requirement to produce two-way replication, I would probably try to implement this through triggers so that I can have lots of control of the process.

Before I could give you more help, I'd need to know which versions of Oracle you are using and what conflicts you need to resolve.

For More Information


This was first published in May 2001

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close