Oracle DBMS_AQ_IMP_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 Undocumented
AUTHID CURRENT_USER
Dependencies
DBMS_AQ_IMP_ZECURITY DBMS_STREAMS_DATAPUMP_UTIL SH$QTAB_PMAP_LIST
DBMS_AQ_SYS_IMP_INTERNAL DBMS_SYS_ERROR SH$SHARD_META_LIST
DBMS_LOGREP_UTIL SH$DEQ_PMAP_LIST SH$SUB_META_LIST
Documented No
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC

Some subprograms appear to be protected by an Accessible By clause and others are not as demonstrated below.
Source {ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
{ORACLE_HOME}/rdbms/admin/prvtaqme.plb
Subprograms
 
BUMP_TID_SEQUENCE
Undocumented dbms_aq_imp_internal.bump_tid_sequence(minval IN NUMBER);
exec dbms_aq_imp_internal.bump_tid_sequence(1);
BEGIN dbms_aq_imp_internal.bump_tid_sequence(1); END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 581
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 616
ORA-06512: at "SYS.DBMS_AQ_IMP_INTERNAL", line 197
ORA-06512: at line 1
 
CLEANUP_SCHEMA_IMPORT
Undocumented dbms_aq_imp_internal.cleanup_schema_import;
exec dbms_aq_imp_internal.cleanup_schema_import;

PL/SQL procedure successfully completed.
 
IMPORT_CMT_TIME_TABLE
Undocumented dbms_aq_imp_internal.import_cmt_time_table(iot IN VARCHAR2);
TBD
 
IMPORT_DEQUEUELOG_TABLE
Undocumented dbms_aq_imp_internal.import_dequeuelog_table(dequeuelog IN VARCHAR2);
TBD
 
IMPORT_HISTORY_TABLE
Undocumented dbms_aq_imp_internal.import_history_table(iot IN VARCHAR2);
TBD
 
IMPORT_INDEX_TABLE
Undocumented dbms_aq_imp_internal.import_index_table(iot IN VARCHAR2);
TBD
 
IMPORT_QUEUE
Undocumented dbms_aq_imp_internal.import_queue(
oid         IN RAW,
queue_table IN VARCHAR2,
queue       IN VARCHAR2,
queue_type  IN NUMBER,
max_retries IN NUMBER,
retry_delay IN NUMBER,
queue_flags IN NUMBER,
retention   IN NUMBER,
comment     IN VARCHAR2);
TBD
 
IMPORT_QUEUE_DQTMAP
Undocumented dbms_aq_imp_internal.import_queue_dqtmap(
dqtlist IN sys.sh$deq_pmap_list,
tname   IN VARCHAR2,
sschema IN VARCHAR2);
TBD
 
IMPORT_QUEUE_META
Undocumented dbms_aq_imp_internal.import_queue_meta(
qname        IN VARCHAR2,
qsschema     IN VARCHAR2,
subshardsize IN NUMBER,
version      IN NUMBER);
TBD
 
IMPORT_QUEUE_QTMAP
Undocumented dbms_aq_imp_internal.import_queue_qtmap(
qtlist  IN sys.sh$qtab_pmap_list,
tname   IN VARCHAR2,
sschema IN VARCHAR2);
TBD
 
IMPORT_QUEUE_SEQ
Undocumented dbms_aq_imp_internal.import_queue_seq(
name    IN VARCHAR2,
qschema IN VARCHAR2,
shidcvl IN BINARY_INTEGER,
seqcvl  IN BINARY_INTEGER,
subcvl  IN BINARY_INTEGER,
rulecvl IN BINARY_INTEGER);
TBD
 
IMPORT_QUEUE_SHARDED_TABLE
Undocumented dbms_aq_imp_internal.import_queue_sharded_table(
schema             IN VARCHAR2,
table_name         IN VARCHAR2,
userdata_type      IN NUMBER,
table_flags        IN NUMBER,
sort_cols          IN NUMBER,
primary_instance   IN BINARY_INTEGER,
secondary_instance IN BINARY_INTEGER,
comment            IN VARCHAR2,
timezone           IN VARCHAR2,
version            IN NUMBER);
TBD
 
IMPORT_QUEUE_SHARDS
Undocumented dbms_aq_imp_internal.import_queue_shards(
shardlist IN sys.sh$shard_meta_list,
qname     IN VARCHAR2,
sschema   IN VARCHAR2);
TBD
 
IMPORT_QUEUE_SUBS
Undocumented dbms_aq_imp_internal.import_queue_subs(
sublist IN sys.sh$sub_meta_list,
qname   IN VARCHAR2,
sschema IN VARCHAR2);
TBD
 
IMPORT_QUEUE_TABLE
Undocumented dbms_aq_imp_internal.import_queue_table(
table_name         IN VARCHAR2,
userdata_type      IN NUMBER,
table_flags        IN NUMBER,
sort_cols          IN NUMBER,
primary_instance   IN BINARY_INTEGER,
secondary_instance IN BINARY_INTEGER,
comment            IN VARCHAR2,
db_version         IN BINARY_INTEGER,
timezone           IN VARCHAR2);
TBD
 
IMPORT_SIGNATURE_TABLE
Undocumented dbms_aq_imp_internal.import_signature_table(iot IN VARCHAR2);
TBD
 
IMPORT_SUBSCRIBER_TABLE
Undocumented dbms_aq_imp_internal.import_subscriber_table(subscriber_table IN VARCHAR2);
TBD
 
IMPORT_TIMEMGR_TABLE
Undocumented dbms_aq_imp_internal.import_timemgr_table(iot IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AQ_IMPORT_INTERNAL
DBMS_AQ_IMPORT_INTERNAL_DR
DBMS_AQ_IMP_ZECURITY
DBMS_AQ_SYS_IMP_INTERNAL
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