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
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