Viewing Conflict Resolution Information

Oracle provides replication catalog (REPCAT) views that you can use to determine what conflict resolution methods are being used by each of the tables and column groups in your replicated environment. Each view has three versions: USER_*, ALL_*, SYS.DBA_*. The views available include the following:

ALL_REPRESOLUTION_ METHOD	Lists all of the available conflict resolution methods.
ALL_REPCOLUMN_GROUP	Lists all of the column groups defined for the database.
ALL_REPGROUPED_COLUMN	Lists all of the columns in each column group in the database.
ALL_REPPRIORITY_GROUP	Lists all of the priority groups and site priority groups defined for the database.
ALL_REPPRIORITY	Lists the values and corresponding priority levels for each priority or site priority group.
ALL_REPCONFLICT	Lists the types of conflicts (delete, update, or uniqueness) for which you have specified a resolution method, for the tables, column groups, and unique constraints in the database.
ALL_REPRESOLUTION	Shows more specific information about the conflict resolution method used to resolve conflicts on each object.
ALL_REPPARAMETER_COLUMN	Shows which columns are used by the conflict resolution methods to resolve a conflict.

See Also: Chapter 9, "Data Dictionary Views".