Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Internal supporting package providing subprograms to start, stop, and configure apply processes.
dbms_apply_adm_internal.alter_apply(
apply_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
rule_set_name IN VARCHAR2,
remove_rule_set IN BOOLEAN,
message_handler IN VARCHAR2,
remove_message_handler IN BOOLEAN,
ddl_handler IN VARCHAR2,
remove_ddl_handler IN BOOLEAN,
apply_user IN VARCHAR2,
apply_tag IN RAW,
remove_apply_tag IN BOOLEAN,
precommit_handler IN VARCHAR2,
remove_precommit_handler IN BOOLEAN,
negative_rule_set_name IN VARCHAR2,
remove_negative_rule_set IN BOOLEAN,
uan_handler IN VARCHAR2,
remove_uan_handler IN BOOLEAN,
ua_rule_set_name IN VARCHAR2,
remove_ua_rule_set IN BOOLEAN,
queue_name IN VARCHAR2);
dbms_apply_adm_internal.alter_object_error_notifier(
alter_mode IN BINARY_INTEGER,
source_object_name IN VARCHAR2,
source_object_type IN VARCHAR2,
apply_name IN VARCHAR2,
error_notifier IN VARCHAR2);
dbms_apply_adm_internal.compare_old_values_inner(
object_name IN VARCHAR2,
column_table IN sys.dbms_utility.lname_array,
operation IN VARCHAR2,
compare IN BOOLEAN,
all_columns IN BOOLEAN,
apply_database_link IN VARCHAR2,
canon_invoker IN VARCHAR2);
dbms_apply_adm_internal.create_apply(
queue_name IN VARCHAR2,
apply_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
rule_set_name IN VARCHAR2,
message_handler IN VARCHAR2,
ddl_handler IN VARCHAR2,
apply_user IN VARCHAR2,
canon_apply_database_link IN VARCHAR2,
apply_tag IN RAW,
apply_captured IN BOOLEAN,
call_aq IN BOOLEAN,
precommit_handler IN VARCHAR2,
i_customer_id IN BINARY_INTEGER,
start_date IN DATE,
end_date IN DATE,
negative_rule_set_name IN VARCHAR2,
source_database IN VARCHAR2,
uan_handler IN VARCHAR2,
ua_rule_set_name IN VARCHAR2,
assemble_lobs IN BOOLEAN,
applyproc_flags IN BINARY_INTEGER,
source_root_name IN VARCHAR2,
lcrid_version IN NUMBER);
dbms_apply_adm_internal.drop_apply(
apply_name IN VARCHAR2,
drop_unused_rule_sets IN BOOLEAN,
canon_invoker IN VARCHAR2,
drop_unused_xstream_objs IN BOOLEAN)
TBD
Overload 2
dbms_apply_adm_internal.drop_apply(
apply_name IN VARCHAR2,
canon_invoker IN VARCHAR2);
dbms_apply_adm_internal.drop_apply_progress_redo(
app_num IN NUMBER,
xidusn IN NUMBER,
xidslt IN NUMBER,
xidsqn IN NUMBER,
cscn IN NUMBER,
spare1 IN NUMBER,
commit_pos IN RAW,
txid IN VARCHAR2);
dbms_apply_adm_internal.handle_collisions(
apply_name IN VARCHAR2,
enable IN BOOLEAN,
object IN VARCHAR2,
source_object IN VARCHAR2,
canon_invoker IN VARCHAR2);
dbms_apply_adm_internal.invalidate_dest_obj(
canon_schema_name IN VARCHAR2,
canon_object_name IN VARCHAR2,
canon_apply_name IN VARCHAR2,
canon_src_schema IN VARCHAR2,
canon_src_name IN VARCHAR2);
dbms_apply_adm_internal.populate_apply_progress(
apply_num IN NUMBER,
tab_name IN VARCHAR2,
scn_time IN DATE,
cscn IN NUMBER,
cpos IN RAW,
is_logical_standby IN BOOLEAN);
dbms_apply_adm_internal.populate_progress_redo(
apply_num IN NUMBER,
tab_name IN VARCHAR2,
lwm_scn IN NUMBER,
lwm_position IN RAW,
source_db_name IN VARCHAR2,
xstreams IN BOOLEAN,
is_logical_standby IN BOOLEAN,
is_gg_xin IN BOOLEAN,
start_time IN DATE,
end_time IN DATE,
start_scn IN NUMBER,
end_scn IN NUMBER,
resetlogs_time IN DATE,
resetlogs_scn IN NUMBER,
is_continuous IN BOOLEAN);
dbms_apply_adm_internal.register_remote_object(
canon_schema_name IN VARCHAR2,
canon_object_name IN VARCHAR2,
canon_dblink IN VARCHAR2,
canon_invoker IN VARCHAR2);
dbms_apply_adm_internal.set_constraint_columns(
constraint_name IN VARCHAR2,
object_name IN VARCHAR2,
column_table IN sys.dbms_utility.name_array,
canon_invoker IN VARCHAR2);
dbms_apply_adm_internal.set_dml_conflict_handler(
apply_name IN VARCHAR2,
conflict_handler_name IN VARCHAR2,
object IN VARCHAR2,
operation_name IN VARCHAR2,
conflict_type IN VARCHAR2,
method_name IN VARCHAR2,
column_list IN VARCHAR2,
resolution_column IN VARCHAR2,
source_object IN VARCHAR2,
canon_invoker IN VARCHAR2);
TBD
Overload 2
dbms_apply_adm_internal.set_dml_conflict_handler(
apply_name IN VARCHAR2,
conflict_handler_name IN VARCHAR2,
object IN VARCHAR2,
operation_name IN VARCHAR2,
conflict_type IN VARCHAR2,
method_name IN VARCHAR2,
column_table IN sys.dbms_utility.lname_array,
resolution_column IN VARCHAR2,
source_object IN VARCHAR2,
canon_invoker IN VARCHAR2);
dbms_apply_adm_internal.set_reperror_handler(
apply_name IN VARCHAR2,
object IN VARCHAR2,
error_number IN NUMBER,
method IN VARCHAR2,
source_object IN VARCHAR2,
max_retries IN NUMBER,
delay_csecs IN NUMBER,
canon_invoker IN VARCHAR2);
dbms_apply_adm_internal.set_update_conflict_handler(
object_name IN VARCHAR2,
method_name IN VARCHAR2,
resolution_column IN VARCHAR2,
column_list IN sys.dbms_utility.name_array,
canon_default_user IN VARCHAR2,
canon_apply_dblink IN VARCHAR2);
dbms_apply_adm_internal.unpickle_apply_progress_redo(
sredo IN VARCHAR2,
app_num OUT NUMBER,
xidusn OUT NUMBER,
xidslt OUT NUMBER,
xidsqn OUT NUMBER,
cscn OUT NUMBER,
spare1 OUT NUMBER,
commit_pos OUT RAW,
txid OUT VARCHAR2);
dbms_apply_adm_internal.unpickle_lsby_progress_redo(
sredo IN VARCHAR2,
xidusn OUT NUMBER,
xidslt OUT NUMBER,
xidsqn OUT NUMBER,
cscn OUT NUMBER,
commit_time OUT DATE);
dbms_apply_adm_internal.validate_remote_column(
canon_schema_name IN VARCHAR2,
canon_object_name IN VARCHAR2,
canon_column_name IN VARCHAR2,
canon_dblink IN VARCHAR2,
canon_invoker IN VARCHAR2);