Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOGMNR_CDC_PUBLISH, 7 of 7
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.
DBMS_LOGMNR_CDC_PUBLISH.PURGE ( ) |
Only standard Oracle exceptions (for example, a privilege violation) are returned during a purge operation.
DBMS_LOGMNR_CDC_PUBLISH.PURGE
procedure runs, Change Data Capture performs partition maintenance automatically.
EXECUTE DBMS_LOGMNR_CDC_PUBLISH.PURGE
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|