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 (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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AQADM
DBMS_AQMIGTOOL_SYS
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx