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 DBMS_LOGMNR_CDC_PUBLISH
package.
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.
See Also:
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:
SELECT
statements to retrieve change data from the subscriber views.
|
Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. |
|