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; ...