Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.DROP_conflicttype_RESOLUTION

Purpose

To drop an update, delete, or uniqueness conflict resolution routine. You must call these procedures from the master definition site. The procedure that you must call is determined by the type of conflict that the routine resolves.

Conflict Type Procedure Name
update DROP_UPDATE_RESOLUTION
uniqueness DROP_UNIQUE_RESOLUTION
delete DROP_DELETE_RESOLUTION

For additional information, refer to .

Syntax

The parameters for the DROP_UPDATE_RESOLUTION procedure are described in Table 12 - 139, and the exceptions are listed in Table 12 - 140. The syntax for this procedure is shown below:

DBMS_REPCAT.DROP_UPDATE_RESOLUTION(
			sname		IN	VARCHAR2, 
			oname		IN	VARCHAR2, 
			column_group	IN	VARCHAR2, 
			sequence_no	IN	NUMBER)

The parameters for the DROP_DELETE_RESOLUTION procedure are described in Table 12 - 139, and the exceptions are listed in Table 12 - 140. The syntax for this procedure is shown below:

DBMS_REPCAT.DROP_DELETE_RESOLUTION(
			sname		IN	VARCHAR2, 
			oname		IN	VARCHAR2, 
			sequence_no	IN	NUMBER)

The parameters for the DROP_UNIQUE_RESOLUTION procedure are described in Table 12 - 139, and the exceptions are listed in Table 12 - 140. The syntax for this procedure is shown below:

DBMS_REPCAT.DROP_UPDATE_RESOLUTION(
			sname			IN	VARCHAR2, 
			oname			IN	VARCHAR2, 
			constraint_name	IN	VARCHAR2, 
			sequence_no		IN	NUMBER)

Parameter Description
sname The schema in which the table is located.
oname The name of the table for which you want to drop a conflict resolution routine.
column_group The name of the column group for which you want to drop an update conflict resolution routine.
constraint_name The name of the Unique constraint for which you want to drop a unique conflict resolution routine.
sequence_no The sequence number assigned to the conflict resolution method that you want to drop. This number uniquely identifies the routine.

Table 12 - 139. Parameters for DROP_UPDATE/DELETE/UNIQUE_ RESOLUTION

Exception Description
nonmasterdef The invocation site is not the masterdef site.
missingobject The given object does not exist as a table in the given schema, or if a conflict resolution routine with the given sequence number is not registered.
missingschema The given schema does not exist.

Table 12 - 140. Exceptions for DROP_UPDATE/DELETE/UNIQUE_ RESOLUTION

Conflict Type	Procedure Name
update	`DROP_UPDATE_RESOLUTION`
uniqueness	`DROP_UNIQUE_RESOLUTION`
delete	`DROP_DELETE_RESOLUTION`

Parameter	Description
`sname`	The schema in which the table is located.
`oname`	The name of the table for which you want to drop a conflict resolution routine.
`column_group`	The name of the column group for which you want to drop an update conflict resolution routine.
`constraint_name`	The name of the Unique constraint for which you want to drop a unique conflict resolution routine.
`sequence_no`	The sequence number assigned to the conflict resolution method that you want to drop. This number uniquely identifies the routine.

Exception	Description
nonmasterdef	The invocation site is not the masterdef site.
missingobject	The given object does not exist as a table in the given schema, or if a conflict resolution routine with the given sequence number is not registered.
missingschema	The given schema does not exist.