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 will be available on generic Linux platforms in January and soon on AIX and Windows

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