User-Defined Conflict Resolution Methods, 4 of 4

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".

`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.