PL/SQL Packages DBMS_LOGMNR_CDC_PUBLISH

Change Data Capture (CDC) identifies data in relational tables that has been added to, modified, or removed and publishes the changed data in a form that is usable by an application.

Subprocedures:

CREATE_CHANGE_TABLE  Create a change table in a specified schema and
                     create corresponding Change Data Capture metadata. 

ALTER_CHANGE_TABLE   Add or drop columns for an existing change table,
                     or change the properties of an existing change table. 

DROP_SUBSCRIBER_VIEW Allow the publisher to drop a subscriber view from the
                     subscriber's schema. The view must have been created by
                     a prior call to the PREPARE_SUBSCRIBER_VIEW procedure. 

DROP_SUBSCRIPTION    Allow a publisher to drop a subscription that was created
                     with a prior call to the GET_SUBSCRIPTION_HANDLE procedure. 

DROP_CHANGE_TABLE    Drop an existing change table when there is no more activity
                     on the table. 

PURGE                Monitor usage by all subscriptions, determine which rows are
                     no longer needed by subscriptions, and remove the unneeded
                     rows to prevent change tables from growing endlessly. 

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al
Related Commands:

DBMS_LOGMNR_CDC_SUBSCRIBE
Related Views:

V$LOG V$LOGFILE V$LOGHIST V$LOGMNR_CONTENTS V$LOGMNR_DICTIONARY V$LOGMNR_LOGS V$LOGMNR_PARAMETERS V$LOG_HISTORY


© Copyright SS64.com 1999-2013
Some rights reserved