Oracle7 Server Distributed Systems Volume II: Replicated Data

Dropping a Conflict Resolution Routine

There are separate procedures in the DBMS_REPCAT package for removing conflict resolution routines. Use the DROP_UPDATE_RESOLUTION procedure to drop a given routine for resolving update conflicts for a given column group. Use the DROP_DELETE_RESOLUTION procedure to drop a given routine for resolving delete conflicts for a given table. Use the DROP_UNIQUE_RESOLUTION procedure to drop a given routine for resolving uniqueness conflicts involving a given unique constraint.

These procedures must be called from the master definition site. The routine you designate is not actually dropped from usage until after the next time you generate replication support for the table.

The following example drops the TIMESTAMP resolution method for the ADDRESS column group:

DBMS_REPCAT.DROP_UPDATE_RESOLUTION(
    sname        => 'acctg', 
    oname        => 'orders', 
    column_group => 'address',
    sequence_no  => 1);

Additional Information: The parameters for the DROP_UPDATE_RESOLUTION, DROP_DELETE_RESOLUTION, and DROP_UNIQUE_RESOLUTION procedures are described in Table 12 - 139, and the exceptions are listed in Table 12 - 140.