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.