Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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);
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page