Data Dictionary Views, 12 of 112

ALL_REPCONFLICT

Contains the name of each table accessible to the current user for which a conflict resolution method has been defined and the type of conflict that the method is used to resolve.

Related views:

DBA_REPCONFLICT describes the conflict resolution method for all the tables in the database on which a conflict resolution method has been defined.

USER_REPCONFLICT describes the conflict resolution method for all the tables owned by the current user on which a conflict resolution method has been defined.

Column Datatype NULL Description

SNAME

VARCHAR2(30)

NOT NULL

The name of the schema containing the replicated table.

ONAME

VARCHAR2(30)

NOT NULL

The name of the table for which a conflict resolution method has been defined.

CONFLICT_TYPE

VARCHAR2(10)

The type of conflict that the conflict resolution method is used to resolve: delete, uniqueness, or update.

REFERENCE_NAME

VARCHAR2(30)

NOT NULL

The object to which the method applies. For delete conflicts, this is the table name. For uniqueness conflicts, this is the constraint name. For update conflicts, this is the column group name.

Column	Datatype	NULL	Description
`SNAME`	`VARCHAR2(30)`	`NOT NULL`	The name of the schema containing the replicated table.
`ONAME`	`VARCHAR2(30)`	`NOT NULL`	The name of the table for which a conflict resolution method has been defined.
`CONFLICT_TYPE`	`VARCHAR2(10)`		The type of conflict that the conflict resolution method is used to resolve: delete, uniqueness, or update.
`REFERENCE_NAME`	`VARCHAR2(30)`	`NOT NULL`	The object to which the method applies. For delete conflicts, this is the table name. For uniqueness conflicts, this is the constraint name. For update conflicts, this is the column group name.

Note:
The SNAME column is not present in the USER_REPCONFLICT view.