Oracle | DBMS_AQMIGTOOL

Oracle DBMS_AQMIGTOOL Version 23c

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.

TEQ and TXEVENTQ = "Transactional Event Queue"

AUTHID CURRENT_USER

Dependencies

DBMS_AQADM	DBMS_AQADM_SYSCALLS	DBMS_SYS_ERROR
DBMS_AQADM_INV	DBMS_AQADM_VAR	PLITBLM
DBMS_AQADM_LIB	DBMS_AQMIGTOOL_SYS	TXEVENTQ_MIGREPORT_ARRAY
DBMS_AQADM_SYS	DBMS_ASSERT

Documented No

First Available 23.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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

Subprograms

ABORT_MIGRATION	CHECK_STATUS	INIT_MIGRATION
CHECK_MIGRATED_MESSAGES	CLEAR_UNSUPPORTED_FEATURE_TABLE	PURGE_QUEUE_MESSAGES
CHECK_MIGRATION_MODE	COMMIT_MIGRATION	RECOVER_MIGRATION
CHECK_MIGRATION_TO_TXEVENTQ	DISABLE_MIGRATION_CHECK	RENAME_QUEUE
CHECK_N_CLEAN_MIGRATION

ABORT_MIGRATION (new 23c)

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

TBD

CHECK_MIGRATED_MESSAGES (new 23c)

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_MODE (new 23c)

Undocumented dbms_aqmigtool.check_migration_mode( owner IN VARCHAR2, cq_name IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

CHECK_MIGRATION_TO_TXEVENTQ (new 23c)

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 23c)

Undocumented dbms_aqmigtool.check_n_clean_migration(job_internal IN NUMBER);

TBD

CHECK_STATUS (new 23c)

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 23c)

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

TBD

COMMIT_MIGRATION (new 23c)

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

TBD

DISABLE_MIGRATION_CHECK (new 23c)

Undocumented dbms_aqmigtool.disable_migration_check(cqname IN VARCHAR2);

TBD

INIT_MIGRATION (new 23c)

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 23c)

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

TBD

RECOVER_MIGRATION (new 23c)

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

TBD

RENAME_QUEUE (new 23c)

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

TBD