You have implemented multi-master Oracle/Oracle replication without a provision to
exclude transactions committed by a Replicat process. What errors are likely to occur?
A.
Inserts will generate a primary key uniqueness violation; deletes will generate a ‘no
matching row’ not found error; updates will continue forever.
B.
None: loop detection is on by default in Oracle.
C.
New inserts will be processed without issue; updates and deletes will generate a “row
not found” error.
D.
Updates and deletes will be replicated without issue new inserts will generate a primary
key uniqueness violation.
Explanation:
The correct answer is A. To implement looping detection you may use “TRANLOGOPTIONS EXCLUDEUSER” on parameter files. There are other, but this is the most common.