Data Dictionary Views, 20 of 112

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(30)

NOT NULL

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.

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(30)`	`NOT NULL`	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.