Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.PURGE_MASTER_LOG

Purpose

To remove local messages in the RepCatLog associated with a given identification number, source, or replicated object group. For additional information, refer to

Syntax

The parameters for the PURGE_MASTER_LOG procedure are described in Table 12 - 151, and the exception is listed in Table 12 - 152. If any parameter is NULL, Oracle treats it as a wildcard. The syntax for this procedure is shown below:

DBMS_REPCAT.PURGE_MASTER_LOG(	id	IN	NATURAL, 
					source	IN	VARCHAR2, 
					gname	IN	VARCHAR2)

Parameter Description
id The identification number of the request, as it appears in the RepCatLog view.
source The master site from which the request originated.
gname The name of the replicated object group for which the request was made.

Table 12 - 151. Parameters for PURGE_MASTER_LOG

Exception Description
nonmaster GNAME is not NULL and the invocation site is not a master site.

Table 12 - 152. Exception for PURGE_MASTER_LOG

Parameter	Description
`id`	The identification number of the request, as it appears in the RepCatLog view.
`source`	The master site from which the request originated.
`gname`	The name of the replicated object group for which the request was made.

Exception	Description
nonmaster	GNAME is not NULL and the invocation site is not a master site.