Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Advanced replication 1
QUESTION 1 :
In an environment of replication Muti-Master with 3 masters sites (A, B and
C) , all master sites containing in their main group the same table X filled
with the same data :
- A Local application on site A removes a data D of table X, then validates
(transaction 1).
- Another local application on the site B then tries to update the same data
d of table X (transaction 2).
In this case, Oracle detects a conflict of replication and tries to solve
it.
1. How does Oracle try to resolve this conflict? 2. If Oracle does not manage to resolve this conflict, how does it reacts? 2.1. Are the transactions rolled back ? If yes, which one and on which site??