Oracle | DBMS_AQ_IMP

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

Direct access to this package is prevented by means of an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
{ORACLE_HOME}/rdbms/admin/prvtaqme.plb

Subprograms

BUMP_TID_SEQUENCE	IMPORT_QUEUE	IMPORT_QUEUE_SHARDS
CLEANUP_SCHEMA_IMPORT	IMPORT_QUEUE_DQTMAP	IMPORT_QUEUE_SUBS
IMPORT_CMT_TIME_TABLE	IMPORT_QUEUE_META	IMPORT_QUEUE_TABLE
IMPORT_DEQUEUELOG_TABLE	IMPORT_QUEUE_QTMAP	IMPORT_SIGNATURE_TABLE
IMPORT_HISTORY_TABLE	IMPORT_QUEUE_SEQ	IMPORT_SUBSCRIBER_TABLE
IMPORT_INDEX_TABLE	IMPORT_QUEUE_SHARDED_TABLE	IMPORT_TIMEMGR_TABLE

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