Oracle7 Server Distributed Systems Volume II: Replicated Data
Changing a Conflict Resolution Routine
To change the conflict resolution method used for a table, you need to complete the following steps:
1. Suspend replication activity for the table's object group by calling DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY.
2. Call the appropriate DBMS_REPCAT.ADD_conflicttype_RESOLUTION procedure with the new conflict resolution method.
3. Regenerate replication support for the object by calling either DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT or DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE.
Because it is not necessary to recreate the generated replication triggers and their associated packages, you can save time by using the DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE procedure.
4. Resume replication activity by calling DBMS_REPCAT.RESUME_MASTER_ACTIVITY.
Generating Replication Procedures
To generate the supporting package for a replicated object at all master sites, as well as the audit tables and conflict resolution packages, call the DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE procedure, as shown in the following example:
DBMS_REPCAT.GENERATE_REPLICATION_PACKAGE( sname => 'acct_rec',
oname => 'inventory');
You must call this procedure from the master definition site for the given replicated object. Oracle must successfully create the necessary packages at the master definition site for this procedure to complete successfully. These objects are asynchronously created at the other master sites as described ![[*]](jump.gif)
.
Additional Information: The parameters for the GENERATE_REPLICATION_PACKAGE procedure are described in Table 12 - 143, and the exceptions are listed in Table 12 - 144.