Oracle DBMS_APPLY_ADM_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
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.
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 19c
What's New In 20c-21c

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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx