Oracle | DBMS_AQMIGTOOL

Oracle DBMS_AQMIGTOOL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Utilities supporting Advanced Queuing (AQ) Migration.

TEQ and TXEVENTQ = "Transactional Event Queue"

AUTHID CURRENT_USER

Dependencies

DBMS_AQADM	DBMS_AQADM_SYSCALLS	DBMS_OUTPUT
DBMS_AQADM_INV	DBMS_AQADM_VAR	DBMS_SYS_ERROR
DBMS_AQADM_LIB	DBMS_AQMIGTOOL_SYS	PLITBLM
DBMS_AQADM_SYS	DBMS_ASSERT	TXEVENTQ_MIGREPORT_ARRAY

Documented No

First Available 23ai

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmstmig.plb
{ORACLE_HOME}/rdbms/admin/prvttmig.plb

Subprograms

CANCEL_MIGRATION	CHECK_STATUS	INIT_MIGRATION
CHECK_MIGRATED_MESSAGES	CLEAR_UNSUPPORTED_FEATURE_TABLE	PURGE_QUEUE_MESSAGES
CHECK_MIGRATION_TO_TXEVENTQ	COMMIT_MIGRATION	RECOVER_MIGRATION
CHECK_N_CLEAN_MIGRATION	DISABLE_MIGRATION_CHECK	RENAME_QUEUE

CANCEL_MIGRATION (new 23ai)

Undocumented dbms_aqmigtool.cancel_migration( cqschema IN VARCHAR2, cqname IN VARCHAR2, abortmode IN NUMBER);

TBD

CHECK_MIGRATED_MESSAGES (new 23ai)

Undocumented dbms_aqmigtool.check_migrated_messages( cqschema IN VARCHAR2, cqname IN VARCHAR2, teq_migrated_message IN OUT NUMBER, cq_pending_messages IN OUT NUMBER);

TBD

CHECK_MIGRATION_TO_TXEVENTQ (new 23ai)

Undocumented dbms_aqmigtool.check_migration_to_txeventq( cqname IN VARCHAR2, migration_report IN OUT sys.teq_migreport_array, checkmode IN NUMBER);

TBD

CHECK_N_CLEAN_MIGRATION (new 23ai)

Undocumented dbms_aqmigtool.check_n_clean_migration(job_internal IN NUMBER);

TBD

CHECK_STATUS (new 23ai)

Undocumented dbms_aqmigtool.check_status( cqschema IN VARCHAR2, cqname IN VARCHAR2, status IN OUT VARCHAR2, migration_comment IN OUT VARCHAR2);

TBD

CLEAR_UNSUPPORTED_FEATURE_TABLE (new 23ai)

Undocumented dbms_aqmigtool.clear_unsupported_feature_table( qschema IN VARCHAR2, qname IN VARCHAR2, eraseall IN BOOLEAN);

TBD

COMMIT_MIGRATION (new 23ai)

Undocumented dbms_aqmigtool.commit_migration( cqschema IN VARCHAR2, cqname IN VARCHAR2);

TBD

DISABLE_MIGRATION_CHECK (new 23ai)

Undocumented dbms_aqmigtool.disable_migration_check(cqname IN VARCHAR2);

TBD

INIT_MIGRATION (new 23ai)

Undocumented dbms_aqmigtool.init_migration( cqschema IN VARCHAR2, cqname IN VARCHAR2, teqschema IN VARCHAR2, teqname IN VARCHAR2, mig_mode IN NUMBER, ordering IN NUMBER, suffix IN VARCHAR2);

TBD

PURGE_QUEUE_MESSAGES (new 23ai)

Undocumented dbms_aqmigtool.purge_queue_messages( cqschema IN VARCHAR2, cqname IN VARCHAR2, purge_option IN NUMBER);

TBD

RECOVER_MIGRATION (new 23ai)

Undocumented dbms_aqmigtool.recover_migration( cqschema IN VARCHAR2, cqname IN VARCHAR2, recovery_message OUT VARCHAR2);

TBD

RENAME_QUEUE (new 23ai)

Undocumented dbms_aqmigtool.rename_queue( schema IN VARCHAR2, qname IN VARCHAR2, new_qname IN VARCHAR2);

TBD