Oracle Distributed Systems

Name

DBMS_REPCAT.PURGE_MASTER_LOG

Synopsis

The PURGE_MASTER_LOG procedure removes records from the DBA_REPCATLOG data dictionary view. Records may be removed by ID, originating master, replication group, or schema. If any of the parameters is NULL, it is treated as a wildcard. Specifications differ for Oracle7 and Oracle8 as follows.

Oracle7 specification:

PROCEDURE DBMS_REPCAT.PURGE_MASTER_LOG
   (id IN NATURAL,
    source IN VARCHAR2,
    gname IN VARCHAR2 := '',
    sname IN VARCHAR2 := '');

Oracle8 specification:

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

To clear all entries from the DBA_REPCATLOG data dictionary view, set all parameters to NULL.

Parameters

Parameter Name	Description
id	Identification of the request (i.e., the ID field in DBA_REPCATLOG data dictionary view)
source	Global name of originating master
gname	Name of the replication group for which request was made
sname (Oracle7 only)	Schema name (provided for pre-Oracle 7.3 compatibility)

Exceptions

Exception Name	Number	Description
nonmaster	–23312	The gname is NULL, and calling site is not a master site.

Restrictions

The calling site must be a master site.