A Change Data Capture (CDC) system usually has one publisher that
captures and publishes changes for any number of Oracle source (relational)
tables and many subscribers.
The subscribers, typically applications, use this package to access the published
data.
Subprocedures:
GET_SUBSCRIPTION_HANDLE Create a subscription handle that associates the subscription
with one change set.
SUBSCRIBE Specify the source tables and source columns for which the
subscriber wants to access change data.
ACTIVATE_SUBSCRIPTION Indicate that a subscription is ready to start accessing
change data.
EXTEND_WINDOW Set the subscription window boundaries (low-water and high-water mark)
so that new change data can be seen.
PREPARE_SUBSCRIBER_VIEW Create a subscriber view in the subscriber's schema in which
the subscriber can query the change data encompassed by the
current subscription window.
DROP_SUBSCRIBER_VIEW Drop a subscriber view from the subscriber's schema.
PURGE_WINDOW Set the low-water mark for a subscription window to notify
the capture system that the subscriber is finished processing
a set of change data.
DROP_SUBSCRIPTION Drop a subscription that was created with a prior call to the
GET_SUBSCRIPTION_HANDLE procedure.
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_PUBLISH
Related Views:
V$LOG
V$LOGFILE
V$LOGHIST
V$LOGMNR_CONTENTS
V$LOGMNR_DICTIONARY
V$LOGMNR_LOGS
V$LOGMNR_PARAMETERS
V$LOG_HISTORY