Oracle DBMS_APPLY_ADM_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Internal supporting package providing subprograms to start, stop, and configure apply processes.
AUTHID DEFINER
Dependencies
ALL_PART_TABLES DBMS_LOGREP_LIB OBJ$
ALL_SCHEDULER_JOBS DBMS_LOGREP_UTIL PLITBLM
ALL_SCHEDULER_PROGRAMS DBMS_LOGREP_UTIL_INVOK STREAMS$_APPLY_MILESTONE
ALL_TAB_PARTITIONS DBMS_OUTPUT STREAMS$_APPLY_PROCESS
APPLY$_CONF_HDLR_COLUMNS DBMS_SCHEDULER STREAMS$_APPLY_PROGRESS
APPLY$_DEST_OBJ_OPS DBMS_SQL STREAMS$_CAPTURE_PROCESS
APPLY$_ERROR_HANDLER DBMS_STANDARD STREAMS$_CAPTURE_SERVER
APPLY$_ERROR_HANDLER_SEQUENCE DBMS_STREAMS_ADM STREAMS$_KEY_COLUMNS
COL$ DBMS_STREAMS_ADM_IVK USER$
CONFLICT_HANDLER_ID_SEQ$ DBMS_STREAMS_ADM_UTL V$ARCHIVED_LOG
DBA_APPLY DBMS_STREAMS_ADM_UTL_INVOK V$DATABASE
DBA_APPLY_ERROR DBMS_STREAMS_DECL V$DATABASE_INCARNATION
DBA_SCHEDULER_JOBS DBMS_SYSTEM V$LOG
DBA_TAB_COLUMNS DBMS_SYS_ERROR V$LOGFILE
DBMS_APPLY_ADM DBMS_UTILITY XSTREAM$_DML_CONFLICT_COLUMNS
DBMS_APPLY_ADM_IVK DBMS_XSTREAM_ADM XSTREAM$_DML_CONFLICT_HANDLER
DBMS_APPLY_ERROR DBMS_XSTREAM_ADM_INTERNAL XSTREAM$_HANDLE_COLLISIONS
DBMS_APPLY_PROCESS DBMS_XSTREAM_ADM_UTL XSTREAM$_REPERROR_HANDLER
DBMS_ASSERT DBMS_XSTREAM_GG _DBA_APPLY_CONSTRAINT_COLUMNS
DBMS_CAPTURE_ADM_INTERNAL DBMS_XSTREAM_GG_ADM _DBA_APPLY_OBJECT_CONSTRAINTS
DBMS_LOCK DBMS_XSTREAM_UTL_IVK _DBA_GGXSTREAM_INBOUND
DBMS_LOGMNR DUAL _DBA_GGXSTREAM_OUTBOUND
DBMS_LOGREP_IMP LOGSTDBY$APPLY_MILESTONE _GV$SXGG_APPLY_COORDINATOR
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthapp.plb
{ORACLE_HOME}/rdbms/admin/prvtbapp.plb
Subprograms
 
ADD_OBJECT_CONSTRAINT
Undocumented dbms_apply_adm_internal.add_object_constraint(
object_name        IN VARCHAR2,
parent_object_name IN VARCHAR2,
canon_invoker      IN VARCHAR2);
TBD
 
ALTER_APPLY
Undocumented 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);
TBD
 
ALTER_MONITOR_JOB
Undocumented dbms_apply_adm_internal.alter_monitor_job(
apply_name IN VARCHAR2,
action     IN NUMBER);
TBD
 
ALTER_OBJECT_ERROR_NOTIFIER
Undocumented 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);
TBD
 
CLEAR_ALL_KEY_COLUMNS
Undocumented dbms_apply_adm_internal.clear_all_key_columns;
exec dbms_apply_adm_internal.clear_all_key_columns;
 
CLEAR_KEY_COLUMNS
Undocumented dbms_apply_adm_internal.clear_key_columns(canon_apply_name IN VARCHAR2);
TBD
 
COMPARE_OLD_VALUES_INNER
Undocumented 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);
TBD
 
CREATE_APPLY
Undocumented 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);
TBD
 
DROP_APPLY
Undocumented

Overload 1
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);
TBD
 
DROP_APPLY_PROGRESS_REDO
Undocumented 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);
TBD
 
DROP_OBJECT_CONSTRAINT
Undocumented dbms_apply_adm_internal.drop_object_constraint(
object_name        IN VARCHAR2,
parent_object_name IN VARCHAR2,
canon_invoker      IN VARCHAR2);
TBD
 
GET_APPLY_FROM_TXN_ID
Undocumented dbms_apply_adm_internal.get_apply_from_txn_id(local_transaction_id IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
HANDLE_COLLISIONS
Undocumented dbms_apply_adm_internal.handle_collisions(
apply_name    IN VARCHAR2,
enable        IN BOOLEAN,
object        IN VARCHAR2,
source_object IN VARCHAR2,
canon_invoker IN VARCHAR2);
TBD
 
INVALIDATE_DEST_OBJ
Undocumented 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);
TBD
 
INVALIDATE_TABLE_OBJECT
Undocumented dbms_apply_adm_internal.invalidate_table_object(
canon_schema_name  IN VARCHAR2,
canon_object_name  IN VARCHAR2,
canon_apply_dblink IN VARCHAR2);
TBD
 
MONITOR_APPLY_PROGRESS
Undocumented dbms_apply_adm_internal.monitor_apply_progress(apply_name IN VARCHAR2);
TBD
 
POPULATE_APPLY_PROGRESS
Undocumented 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);
TBD
 
POPULATE_PROGRESS_REDO
Undocumented 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);
TBD
 
REGISTER_REMOTE_OBJECT
Undocumented 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);
TBD
 
RESET_CONFIGURATION
Undocumented dbms_apply_adm_internal.reset_configuration(
server_name   IN VARCHAR2,
reset_options IN BINARY_INTEGER);
TBD
 
SET_CONSTRAINT_COLUMNS
Undocumented 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);
TBD
 
SET_DML_CONFLICT_HANDLER
Undocumented

Overload 1
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);
TBD
 
SET_REPERROR_HANDLER
Undocumented 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);
TBD
 
SET_UPDATE_CONFLICT_HANDLER
Undocumented 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);
TBD
 
SYNC_PDB_PARTITIONS
Undocumented dbms_apply_adm_internal.sync_pdb_partitions(
p_src_tab  IN VARCHAR2,
p_dest_tab IN VARCHAR2,
test       IN BOOLEAN);
TBD
 
UNPICKLE_APPLY_PROGRESS_REDO
Undocumented 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);
TBD
 
UNPICKLE_LSBY_PROGRESS_REDO
Undocumented 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);
TBD
 
UNPICKLE_PROGRESS_REDO_META
Undocumented dbms_apply_adm_internal.unpickle_progress_redo_meta(
sredo       IN  VARCHAR2,
marker_ver  OUT NUMBER,
marker_type OUT NUMBER);
TBD
 
VALIDATE_REMOTE_COLUMN
Undocumented 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);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_APPLY_ADM
DBMS_APPLY_ADM_IVK
DBMS_APPLY_PROCESS
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx