René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

dbms_cdc_publish

Procedures/Functions

alter_autolog_change_source

procedure alter_autolog_change_source (
 change_source_name                 in                 varchar2        ,
 description                        in                 varchar2 default,
 remove_description                 in                     char default,
 first_scn                          in                   number default
);

alter_change_set

procedure alter_change_set (
 change_set_name                    in                 varchar2        ,
 description                        in                 varchar2 default,
 remove_description                 in                     char default,
 enable_capture                     in                     char default,
 recover_after_error                in                     char default,
 remove_ddl                         in                     char default,
 stop_on_ddl                        in                     char default
);

alter_change_table

procedure alter_change_table (
 owner                              in                 varchar2        ,
 change_table_name                  in                 varchar2        ,
 operation                          in                 varchar2        ,
 column_list                        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        
);

create_autolog_change_source

procedure create_autolog_change_source (
 change_source_name                 in                 varchar2        ,
 description                        in                 varchar2 default,
 source_database                    in                 varchar2        ,
 first_scn                          in                   number        
);

create_change_set

procedure create_change_set (
 change_set_name                    in                 varchar2        ,
 description                        in                 varchar2 default,
 change_source_name                 in                 varchar2        ,
 stop_on_ddl                        in                     char default,
 begin_date                         in                     date default,
 end_date                           in                     date default
);

create_change_table

procedure create_change_table (
 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        
);

drop_change_set

procedure drop_change_set (
 change_set_name                    in                 varchar2        
);

drop_change_source

procedure drop_change_source (
 change_source_name                 in                 varchar2        
);

drop_change_table

procedure drop_change_table (
 owner                              in                 varchar2        ,
 change_table_name                  in                 varchar2        ,
 force_flag                         in                     char        
);

drop_subscriber_view

procedure drop_subscriber_view (
 subscription_handle                in                   number        ,
 source_schema                      in                 varchar2        ,
 source_table                       in                 varchar2        
);

drop_subscription

procedure drop_subscription (
 subscription_name                  in                 varchar2        
);
procedure drop_subscription (
 subscription_handle                in                   number        
);

purge

procedure purge (
);

purge_change_set

procedure purge_change_set (
 change_set_name                    in                 varchar2        
);

purge_change_table

procedure purge_change_table (
 owner                              in                 varchar2        ,
 change_table_name                  in                 varchar2        
);

Links