Name
DBMS_SNAPSHOT.PURGE_LOG
Synopsis
Call the PURGE_LOG procedure to delete snapshot log records.
PROCEDURE DBMS_SNAPSHOT.PURGE_LOG
(master VARCHAR2,
num BINARY_INTEGER DEFAULT 1,
flag VARCHAR2 DEFAULT 'NOP' );To delete all records from a snapshot log, set the num parameter to a high value (greater than the number of snapshots mastered to the master table, specified in the master parameter).
The PURGE_LOG procedure does not raise any exceptions, and there are no restrictions on calling it.
Parameters
Parameter Name | Description |
|---|---|
master | Name of the master table. |
num | Delete records required to refresh the oldest number of unrefreshed snapshot; default is 1. |
flag | Set to DELETE to guarantee that records are deleted for at least one snapshot regardless of the setting of num. |