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