Purge_Master_Log

PURGE_MASTER_LOG

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);

Example:

SQL> select id,source,gname,timestamp from dba_repcatlog;

ID

----------

SOURCE

--------------------------------------------------------------------------------

GNAME TIMESTAMP

------------------------------ ---------

1801

SAMIDB.SAMIINDIA

SAMIQC 17-OCT-07

SQL> begin

dbms_repcat.purge_master_log (

id => 1801,

source => 'samidb.samiindia',

gname => 'samiqc' );

end;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> select id,source,gname,timestamp from dba_repcatlog;

no rows selected