PURGE_MASTER_LOG Procedure

This procedure removes local messages in the DBA_REPCATLOG view associated with a specified identification number, source, or master group.

To purge all of the administrative requests from a particular source, specify NULL for the id parameter. To purge all administrative requests from all sources, specify NULL for both the id parameter and the source parameter.

Syntax

DBMS_REPCAT.PURGE_MASTER_LOG (
   id      IN   BINARY_INTEGER, 
   source  IN   VARCHAR2, 
   gname   IN   VARCHAR2);

Parameters

Table 18-104 PURGE_MASTER_LOG Procedure Parameters

Parameter	Description
id	Identification number of the request, as it appears in the `DBA_REPCATLOG` view.
source	Master site from which the request originated.
gname	Name of the master group for which the request was made.

Exceptions

Table 18-105 PURGE_MASTER_LOG Procedure Exceptions

Exception	Description
nonmaster	`gname` is not `NULL`, and the invocation site is not a master site.