Oracle in a Nutshell

Calls

PROCEDURE DBMS_LOGMNR_CDC_SUBSCRIBE.GET_SUBSCRIPTION_HANDLE (change_set IN VARCHAR2, description IN VARCHAR2 := NULL, subscription_handle OUT NUMBER);

Gets a subscription_handle associated with change_set.

PROCEDURE DBMS_LOGMNR_CDC_SUBSCRIBE.SUBSCRIBE (subscription_handle IN NUMBER, source_schema IN VARCHAR2, source_table IN VARCHAR2, column_list IN VARCHAR2); PROCEDURE DBMS_LOGMNR_CDC_SUBSCRIBE.SUBSCRIBE (subscription_handle IN NUMBER, publication_id IN NUMBER, column_list IN VARCHAR2);

Specifies the source tables and columns for the subscriber, by their identities or by the publication_id of a specific publication.

PROCEDURE DBMS_LOGMNR_CDC_SUBSCRIBE.ACTIVATE_SUBSCRIBER (subscription_handle IN NUMBER);

Makes subscription_handle ready to start accessing change data.

PROCEDURE DBMS_LOGMNR_CDC_SUBSCRIBE.EXTEND_WINDOW (subscription_handle IN NUMBER);

Sets window boundaries for subscription_handle so that new change data can be seen.

PROCEDURE DBMS_LOGMNR_CDC_SUBSCRIBE.PREPARE_SUBSCRIBER_VIEW (subscription_handle IN NUMBER, source_schema IN VARCHAR2, source_table IN VARCHAR2, view_name OUT VARCHAR2);

Creates view_name in subscriber’s schema to receive change data from source_table.

PROCEDURE DBMS_LOGMNR_CDC_SUBSCRIBE.DROP_SUBSCRIBER_VIEW (subscription_handle IN NUMBER, source_schema IN VARCHAR2, source_table IN VARCHAR2);

Drops subscriber view for subscription_handle in subscriber’s schema.

PROCEDURE DBMS_LOGMNR_CDC_SUBSCRIBE.PURGE_WIND)W (subscription_handle IN NUMBER);