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