|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)
Part Number A96612-01
This chapter describes how to use the
DBMS_LOGMNR_CDC_SUBSCRIBE package to view and query the change data that was captured and published with the
A Change Data Capture 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 the Oracle supplied package,
DBMS_LOGMNR_CDC_SUBSCRIBE, to access the published data.
Oracle9i Data Warehousing Guide for more information about the Oracle Change Data Capture publish and subscribe model.
This chapter discusses the following topics:
Once the publisher sets up the system to capture data into change tables and grants access, subscribers can access and query the published change data for any of the source tables of interest. Using the procedures in the
DBMS_LOGMNR_CDC_SUBSCRIBE package, the subscriber accomplishes the following main objectives:
SELECTstatements to retrieve change data from the subscriber views.