Oracle DBMS_AQ_SYS_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 DEFINER
Dependencies
AQ$_DEQUEUE_LOG_PARTITION_MAP DBMS_AQ_EXP_QUEUES OBJ$
AQ$_DURABLE_SUBS DBMS_AQ_EXP_QUEUE_TABLES PLITBLM
AQ$_IOTENQTXID DBMS_AQ_IMP_INTERNAL SH$DEQ_PMAP
AQ$_QUEUES DBMS_AQ_SYS_EXP_INTERNAL SH$DEQ_PMAP_LIST
AQ$_QUEUE_PARTITION_MAP DBMS_ASSERT SH$QTAB_PMAP
AQ$_QUEUE_SHARDS DBMS_DATAPUMP SH$QTAB_PMAP_LIST
AQ$_QUEUE_TABLES DBMS_INTERNAL_LOGSTDBY SH$SHARD_META
AQ$_QUEUE_TABLE_AFFINITIES DBMS_PRVTAQIM SH$SHARD_META_LIST
DBA_INDEXES DBMS_PRVTAQIS SH$SUB_META
DBA_OBJECTS DBMS_RULEADM_INTERNAL SH$SUB_META_LIST
DBMS_AQADM DUAL TAB$
DBMS_AQADM_INV EXPDEPOBJ$ TABPART$
DBMS_AQADM_SYS KU$_JOBSTATUS1220 TS$
DBMS_AQADM_SYSCALLS KU$_STATUS USER$
DBMS_AQINT_LIB    
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
{ORACLE_HOME}/rdbms/admin/prvtaqmi.plb
Subprograms
 
BUMP_TID_SEQUENCE
Undocumented dbms_aq_sys_imp_internal.bump_tid_sequence(minval IN NUMBER);
exec dbms_aq_sys_imp_internal.bump_tid_sequence(1);

PL/SQL procedure successfully completed.
 
CLEANUP_SCHEMA_IMPORT
Undocumented dbms_aq_sys_imp_internal.cleanup_schema_import(schema IN VARCHAR2);
exec dbms_aq_sys_imp_internal.cleanup_schema_import('C##SEMOP');

PL/SQL procedure successfully completed.
 
CREATE_PMAP_DICTIONARY
Undocumented dbms_aq_sys_imp_internal.create_pmap_dictionary(
qt_schema          IN  VARCHAR2,
tschema            IN  VARCHAR2,
qt_name            IN  VARCHAR2,
user_data_type     IN  NUMBER,
qt_flags           IN  NUMBER,
sort_cols          IN  VARCHAR2,
primary_instance   IN  BINARY_INTEGER,
secondary_instance IN  BINARY_INTEGER,
qt_comment         IN  VARCHAR2,
qt_timezone        IN  VARCHAR2,
owner_instance     OUT BINARY_INTEGER);
TBD
 
IMPORT_CMT_TIME_TABLE
Undocumented dbms_aq_sys_imp_internal.import_cmt_time_table(
schema      IN VARCHAR2,
queue_table IN VARCHAR2,
iot         IN VARCHAR2);
TBD
 
IMPORT_DEQUEUELOG_TABLE
Undocumented dbms_aq_sys_imp_internal.import_dequeuelog_table(
schema      IN VARCHAR2,
queue_table IN VARCHAR2,
dequeuelog  IN VARCHAR2);
TBD
 
IMPORT_EXP_ENTRY
Undocumented dbms_aq_sys_imp_internal.import_exp_entry(
usern       IN NUMBER,
qtobjn      IN NUMBER,
objectnm    IN VARCHAR2,
object_type IN NUMBER);
TBD
 
IMPORT_HISTORY_TABLE
Undocumented dbms_aq_sys_imp_internal.imort_history_table(
schema      IN VARCHAR2,
queue_table IN VARCHAR2,
iot         IN VARCHAR2);
TBD
 
IMPORT_INDEX_TABLE
Undocumented dbms_aq_sys_imp_internal.import_index_table(
schema      IN VARCHAR2,
queue_table IN VARCHAR2,
iot         IN VARCHAR2);
TBD
 
IMPORT_QTAB_EXPDEP
Undocumented dbms_aq_sys_imp_internal.import_qtab_expdep(
qt_name   IN VARCHAR2,
qt_schema IN VARCHAR2);
TBD
 
IMPORT_QUEUE
Undocumented dbms_aq_sys_imp_internal.import_queue(
oid         IN RAW,
schema      IN VARCHAR2,
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_sys_imp_internal.import_queue_dqtmap(
dqtlist IN sys.sh$deq_pmap_list,
tname   IN VARCHAR2,
sschema IN VARCHAR2,
tschema IN VARCHAR2);
TBD
 
IMPORT_QUEUE_META
Undocumented dbms_aq_sys_imp_internal.import_queue_meta(
qname    IN VARCHAR2,
qsschema IN VARCHAR2,
schema   IN VARCHAR2,
subsize  IN NUMBER,
version  IN NUMBER);
TBD
 
IMPORT_QUEUE_QTMAP
Undocumented dbms_aq_sys_imp_internal.import_queue_qtmap(
qtlist  IN sys.sh$qtab_pmap_list,
tname   IN VARCHAR2,
sschema IN VARCHAR2,
tschema IN VARCHAR2);
TBD
 
IMPORT_QUEUE_SEQ
Undocumented dbms_aq_sys_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_sys_imp_internal.import_queue_sharded_table(
schema             IN VARCHAR2,
tschema            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_sys_imp_internal.import_queue_shards(
shardlist IN sys.sh$shard_meta_list,
qname     IN VARCHAR2,
sschema   IN VARCHAR2,
tschema   IN VARCHAR2);
TBD
 
IMPORT_QUEUE_SUBS
Undocumented dbms_aq_sys_imp_internal.import_queue_subs(
sublist IN sys.sh$sub_meta_list,
qname   IN VARCHAR2,
sschema IN VARCHAR2,
tschema IN VARCHAR2);
TBD
 
IMPORT_QUEUE_TABLE
Undocumented dbms_aq_sys_imp_internal.import_queue_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,
db_version         IN BINARY_INTEGER,
timezone           IN VARCHAR2);
TBD
 
IMPORT_SIGNATURE_TABLE
Undocumented dbms_aq_sys_imp_internal.import_signature_table(
schema      IN VARCHAR2,
queue_table IN VARCHAR2,
iot         IN VARCHAR2);
TBD
 
IMPORT_SUBSCRIBER_TABLE
Undocumented dbms_aq_sys_imp_internal.import_subscriber_table(
schema           IN VARCHAR2,
queue_table      IN VARCHAR2,
subscriber_table IN VARCHAR2);
TBD
 
IMPORT_TIMEMGR_TABLE
Undocumented dbms_aq_sys_imp_internal.import_timemgr_table(
schema      IN VARCHAR2,
queue_table IN VARCHAR2,
iot         IN VARCHAR2);
TBD
 
IS_TTS_EXPORT
Undocumented dbms_aq_sys_imp_internal.is_tts_export RETURN BOOLEAN;
BEGIN
  IF dbms_aq_sys_imp_internal.is_tts_export THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
I_SHARDED_CALLOUT
Undocumented dbms_aq_sys_imp_internal.i_sharded_callout(
name    IN VARCHAR2,
schema  IN VARCHAR2,
prepost IN BINARY_INTEGER);
TBD
 
POST_TTS_REBUILD_IDX
Undocumented dbms_aq_sys_imp_internal.post_tts_rebuild_idx(
schema      IN VARCHAR2,
queue_table IN VARCHAR2);
TBD
 
POST_TTS_SHARDED_Q
Undocumented dbms_aq_sys_imp_internal.post_ttx_sharded_q(
schema      IN VARCHAR2,
queue_table IN VARCHAR2);
TBD
 
POST_TTS_WORK
Undocumented dbms_aq_sys_imp_internal.post_tts_work(
schema      IN VARCHAR2,
queue_table IN VARCHAR2);
TBD
 
POST_TTS_WORK_REMAINING
Undocumented dbms_aq_sys_imp_internal.post_tts_work_remaining(
schema      IN VARCHAR2,
queue_table IN VARCHAR2);
TBD

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