Replication Catalog Views, 19 of 81

ALL_REPPARAMETER_COLUMN

In addition to the information contained in the ALL_REPRESOLUTION view, the ALL_REPPARAMETER_COLUMN view contains information about the columns that are used to resolve conflicts for each replicated table accessible to the current user. These are the column values that are passed as the list_of_column_names argument to the ADD_conflicttype_RESOLUTION procedures in the DBMS_REPCAT package.

Related Views:

DBA_REPPARAMETER_COLUMN contains information about the columns that are used to resolve conflicts for each replicated table in the database.

USER_REPPARAMETER_COLUMN contains information about the columns that are used to resolve conflicts for each replicated table owned by the current user.

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 replicated table.
`CONFLICT_TYPE`	`VARCHAR2(10)`		The type of conflict that the 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.
`SEQUENCE_NO`	`NUMBER`	`NOT NULL`	The order in which resolution methods are applied, with 1 applied first.
`METHOD_NAME`	`VARCHAR2(80)`	`NOT NULL`	The name of an Oracle-supplied conflict resolution method. For user-supplied methods, this value is 'user function'.
`FUNCTION_NAME`	`VARCHAR2(92)`	`NOT NULL`	For methods of type 'user function', the name of the user-supplied conflict resolution method.
`PRIORITY_GROUP`	`VARCHAR2(30)`		For methods of name 'priority group', the name of the priority group.
`PARAMETER_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Displays the name of the table to which the parameter column belongs.
`PARAMETER_COLUMN_NAME`	`VARCHAR2(4000)`		The name of the column used as the `IN` parameter for the conflict resolution method.
`PARAMETER_SEQUENCE_NO`	`NUMBER`	`NOT NULL`	Ordering of column used as `IN` parameter.

Note:

The SNAME column is not present in the USER_REPPARAMETER_COLUMN view.