December 2002
Intermediate to advanced
928 pages
85h 29m
English
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);