Oracle | DBMS_AQ_SYS_IMP

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	IMPORT_QUEUE	IMPORT_SIGNATURE_TABLE
CLEANUP_SCHEMA_IMPORT	IMPORT_QUEUE_DQTMAP	IMPORT_SUBSCRIBER_TABLE
CREATE_PMAP_DICTIONARY	IMPORT_QUEUE_META	IMPORT_TIMEMGR_TABLE
IMPORT_CMT_TIME_TABLE	IMPORT_QUEUE_QTMAP	IS_TTS_EXPORT
IMPORT_DEQUEUELOG_TABLE	IMPORT_QUEUE_SEQ	I_SHARDED_CALLOUT
IMPORT_EXP_ENTRY	IMPORT_QUEUE_SHARDED_TABLE	POST_TTS_REBUILD_IDX
IMPORT_HISTORY_TABLE	IMPORT_QUEUE_SHARDS	POST_TTS_SHARDED_Q
IMPORT_INDEX_TABLE	IMPORT_QUEUE_SUBS	POST_TTS_WORK
IMPORT_QTAB_EXPDEP	IMPORT_QUEUE_TABLE	POST_TTS_WORK_REMAINING

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