Oracle7 Server Distributed Systems Volume II: Replicated Data

Viewing Conflict Resolution Information

The symmetric replication facility provides several 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:

RepResolution_Method Lists all of the available conflict resolution methods.
RepColumn_Group Lists all of the column groups defined for the database.
RepGrouped_Column Lists all of the columns in each column group in the database.
RepPriority_Group Lists all of the priority groups and site priority groups defined for the database.
RepPriority Lists the values and corresponding priority levels for each priority or site priority group.
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.
RepResolution Shows more specific information about the conflict resolution method used to resolve conflicts on each object.
RepParameter_Column Shows which columns are used by the conflict resolution routines to resolve a conflict.

RepResolution_Method	Lists all of the available conflict resolution methods.
RepColumn_Group	Lists all of the column groups defined for the database.
RepGrouped_Column	Lists all of the columns in each column group in the database.
RepPriority_Group	Lists all of the priority groups and site priority groups defined for the database.
RepPriority	Lists the values and corresponding priority levels for each priority or site priority group.
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.
RepResolution	Shows more specific information about the conflict resolution method used to resolve conflicts on each object.
RepParameter_Column	Shows which columns are used by the conflict resolution routines to resolve a conflict.