Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose
Internal supporting package providing subprograms to start, stop, and configure apply processes.
AUTHID
DEFINER
Dependencies
SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_APPLY_ADM_INTERNAL' UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_APPLY_ADM_INTERNAL'
ORDER BY 1;
query returns 68 objects
Documented
No
First Available
Not known
Security Model
Owned by SYS with EXECUTE granted to GSMADMIN_INTERNAL.
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);