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.