What errors are likely to occur?

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?

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:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


franciscotmjr

franciscotmjr

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.