Oracle7 Server Distributed Systems Volume II: Replicated Data

Removing Log Information

If you resolved an error condition from a replication administration request, you can remove related error messages in the RepCatLog view by calling the PURGE_MASTER_LOG procedure in the DBMS_REPCAT package, as shown in the following example:

DBMS_REPCAT.PURGE_MASTER_LOG(	id	=>	1763,
	source	=>	'acct_ny.ny.com',
	gname	=>	'acct');

This procedure removes all local log records corresponding to the request on the ACCT replicated object group that originated at the ACCT_NY master with the identification number 1763. If any parameter is NULL, Oracle treats it as a wildcard.

Like most other procedures in the DBMS_REPCAT package that are executed at a master site, a side effect of PURGE_MASTER_LOG is to perform any local deferred administrative requests for the given replicated object group. This administration is attempted before the log is purged.

Additional Information: The parameters for the PURGE_MASTER_LOG procedure are described in Table 12 - 151, and the exceptions are listed in Table 12 - 152.