PL/SQL Packages DBMS_LOGMNR_CDC_SUBSCRIBE

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


© Copyright SS64.com 1999-2013
Some rights reserved