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