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_PUBLISH. (owner IN VARCHAR2, change_table_name IN VARCHAR2, change_set_name IN VARCHAR2, source_schema IN VARCHAR2, source_table IN VARCHAR2, column_type_list IN VARCHAR2, capture_values IN VARCHAR2, rs_id IN CHAR, row_id IN CHAR, user_id IN CHAR, timestamp IN CHAR, object_id IN CHAR, source_colmap IN CHAR, target_colmap IN CHAR, options_string IN VARCHAR2);

Creates a change_table_name in owner schema to monitor source_table in source_schema.

PROCEDURE DBMS_LOGMNR_CDC_PUBLISH.ALTER_CHANGE_TABLE (owner IN VARCHAR2, change_table_name IN VARCHAR2, operation IN VARCHAR2, column_list IN VARCHAR2, capture_values IN VARCHAR2, rs_id IN CHAR, row_id IN CHAR, user_id IN CHAR, timestamp IN CHAR, object_id IN CHAR, source_colmap IN CHAR, target_colmap IN CHAR);

Adds columns to (operation ADD) or drops columns from (operation DROP) change_table_name.

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

Drop a subscriber_handle view in source_schema.

PROCEDURE DBMS_LOGMNR_CDC_PUBLISH.DROP_SUBSCRIPTION (subscription_handle IN NUMBER);

Drops subscription_handle obtained with the DBMS_LOGMNR_CDC_SUBSCRIBE.GET_SUBSCRIPTION_HANDLE call.

PROCEDURE DBMS_LOGMNR_CDC_PUBLISH.DROP_CHANGE_TABLE (owner IN VARCHAR2, change_table_name IN VARCHAR2, force IN CHAR);

Drops change_table_name in owner. If force is Y, the table is dropped even if there are subscribers making references to the table; ...

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