I am using two-way replication (updateable snapshot) but am unable to solve an add/update conflict. I already have...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our Oracle guru is waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.