PURGE Procedure

This procedure monitors change table usage by all subscriptions, determines which rows are no longer needed by subscriptions, and removes the unneeded rows to prevent change tables from growing endlessly.

Syntax

DBMS_LOGMNR_CDC_PUBLISH.PURGE ( )

Exceptions

Only standard Oracle exceptions (for example, a privilege violation) are returned during a purge operation.

Usage Notes

• You can run this procedure manually or automatically:
  • Run this procedure manually from the command line at any time that you want to purge data from change tables.

  • Run this procedure in a script to routinely perform a purge operation and proactively control the growth of change tables. You can always remove or disable (or suspend) the purge operation if you want to prevent it from running automatically.

• Use this procedure to control the growth of change tables.

• Do not attempt to control a change table's partitioning properties. When the DBMS_LOGMNR_CDC_PUBLISH.PURGE procedure runs, Change Data Capture performs partition maintenance automatically.

Example

EXECUTE DBMS_LOGMNR_CDC_PUBLISH.PURGE