Skip Headers

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)

Part Number A96612-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

27
DBMS_LOGMNR_CDC_SUBSCRIBE

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:

Subscribing to Change Data

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:

  1. Indicate the change data of interest by creating subscriptions to published source tables and source columns.
  2. Extend the subscription window and create a new subscriber view when the subscriber is ready to receive a set of change data.
  3. Use SELECT statements to retrieve change data from the subscriber views.
  4. Drop the subscriber view and purge the subscription window when finished processing a block of changes.
  5. Drop the subscription when the subscriber no longer needs its change data.

Go to previous page Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback