Oracle DBMS_AQ_SYS_IMP_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 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 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