Oracle DBMS_AQMIGTOOL_SYS
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 DEFINER
Data Types TYPE q_name_list_t IS ....;
Dependencies
ALL_OBJECTS DBMS_AQADM_INV
ANYDATA DBMS_AQADM_LIB
AQ$_BND_ARRAY DBMS_AQADM_SYS
AQ$_DEQUEUE_LOG_PARTITION_MAP DBMS_AQADM_SYSCALLS
AQ$_DURABLE_SUBS DBMS_AQINT_LIB
AQ$_JMS_BYTES_MESSAGE DBMS_AQJMS_INTERNAL
AQ$_JMS_MAP_MESSAGE DBMS_AQMIGTOOL
AQ$_JMS_MESSAGE DBMS_ASSERT
AQ$_JMS_OBJECT_MESSAGE DBMS_LOB
AQ$_JMS_STREAMS_MESSAGE DBMS_METADATA
AQ$_JMS_TEXT_MESSAGE DBMS_PRVTAQIM
AQ$_MIGRATION_STATUS DBMS_PRVTSQDS
AQ$_QUEUE_PARTITION_MAP DBMS_RULEADM_INTERNAL
AQ$_QUEUE_SHARDS DBMS_SCHEDULES
AQ$_RECIPIENTS DBMS_SYS_ERROR
AQ$_REG_INFO DUAL
AQ$_REG_INFO_LIST OBJ$
COL$ PLITBLM
COLTYPE$ REG$
DBA_OBJECTS TXEVENTQ_MIGREPORT
DBMS_AQ TXEVENTQ_MIGREPORT_ARRAY
DBMS_AQADM  
Documented No
First Available 23.1
Security Model Owned by SYS with no privileges granted

It is likely all subprograms in this package are protected by an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/dbmstmig.plb
{ORACLE_HOME}/rdbms/admin/prvttmig.plb
Subprograms
 
ADD_SUBSCRIBER_TO_TXEVENTQ (new 23c)
Undocumented dbms_aqmigtool_sys.add_subscriber_to_txeventq(
cqschema  IN VARCHAR2,
cqname    IN VARCHAR2,
teqschema IN VARCHAR2,
teqname   IN VARCHAR2);
TBD
 
CHECK_CURRENT_COMPATIBILITY (new 23c)
Undocumented dbms_aqmigtool_sys.check_current_compatibility(
q_schema IN VARCHAR2,
q_name   IN VARCHAR2);
TBD
 
CHECK_N_CLEAN_MIGRATION_INT (new 23c)
Undocumented dbms_aqmigtool_sys.check_n_clean_migration_int(job_interval IN NUMBER);
TBD
 
CHECK_UNSUPPORT_FEATURE (new 23c)
Undocumented dbms_aqmigtool_sys.check_unsupport_feature(
qschema      IN  VARCHAR2,
qname        IN  VARCHAR2,
event        OUT VARCHAR2,
eventerr     OUT VARCHAR2,
warningcheck IN  BOOLEAN)
RETURN BOOLEAN;
TBD
 
CLEAR_UNSUPPORTED_FEAT_TABLE_INT (new 23c)
Undocumented dbms_aqmigtool_sys.clear_unsupported_feat_table_int(
qschema      IN VARCHAR2,
qname        IN VARCHAR2,
eraseall     IN BOOLEAN,
current_user IN VARCHAR2);
TBD
 
COPY_MSG_TXEVENTQ_TO_CQ (new 23c)
Undocumented dbms_aqmigtool_sys.copy_msg_txeventq_to_cq(
cq_schema    IN VARCHAR2,
q_name       IN VARCHAR2,
teq_schema   IN VARCHAR2,
teq_name     IN VARCHAR2,
current_user IN VARCHAR2);
TBD
 
COPY_OBJECT_PRIVILEGES (new 23c)
Undocumented dbms_aqmigtool_sys.copy_object_privileges(
schema       IN VARCHAR2,
qname        IN VARCHAR2,
teq_name     IN VARCHAR2,
current_user IN VARCHAR2);
TBD
 
COPY_PLSQL_NOTIFICATION (new 23c)
Undocumented dbms_aqmigtool_sys.copy_plsql_notification(
src_schema  IN VARCHAR2,
src_qname   IN VARCHAR2,
dst_schema  IN VARCHAR2,
dst_qname   IN VARCHAR2,
replace_src IN BOOLEAN);
TBD
 
CREATE_EXCEPTION_QUEUE (new 23c)
Undocumented dbms_aqmigtool_sys.create_exception_queue(
q_schema     IN VARCHAR2,
qt_name      IN VARCHAR2,
teq_schema   IN VARCHAR2,
teq_name     IN VARCHAR2,
current_user IN VARCHAR2);
TBD
 
CREATE_MIG_CLEANUP_JOB (new 23c)
Undocumented

Protected by Accessible By clause
dbms_aqmigtool_sys.create_mig_cleanup_job;
exec dbms_aqmigtool_sys.create_mig_cleanup_job;
 
DELETE_MIG_STATUS (new 23c)
Undocumented dbms_aqmigtool_sys.delete_mig_status(
s_schema   IN VARCHAR2,
s_queue    IN VARCHAR2,
status_p   IN NUMBER,
event_id_p IN NUMBER);
TBD
 
GENERATE_MID (new 23c)
Undocumented

Protected by Accessible By clause
dbms_aqmigtool_sys.generate_mid RETURN RAW;
SELECT dbms_aqmigtool_sys.generate_mid;
 
GENERATE_MIGRATION_REPORT (new 23c)
Undocumented dbms_aqmigtool_sys.generate_migration_report(
q_schema         IN     VARCHAR2,
q_name           IN     VARCHAR2,
migration_report IN OUT sys.teq_migreport_array);
TBD
 
GET_CQ_MSG_COUNT (new 23c)
Undocumented dbms_aqmigtool_sys.get_cq_msg_count(
q_schema   IN VARCHAR2,
q_name     IN VARCHAR2,
only_check IN BOOLEAN)
RETURN NUMBER;
TBD
 
GET_CQ_NAME (new 23c)
Undocumented dbms_aqmigtool_sys.get_cq_name(q_schema IN VARCHAR2)
RETURN sys.dbms_aqmigtool_sys.q_name_list_t;
TBD
 
GET_PARAM_CREATE_TXEVENTQ (new 23c)
Undocumented dbms_aqmigtool_sys.get_param_create_txeventq(
q_schema            IN     VARCHAR2,
q_name              IN     VARCHAR2,
current_user        IN     VARCHAR2,
queue_properties    IN OUT sys.dbms_aqadm.queue_props_t,
storage_clause      IN OUT VARCHAR2,
multiple_consumers  IN OUT BOOLEAN,
max_retries         IN OUT NUMBER,
queue_payload_owner IN OUT VARCHAR2,
queue_payload_type  IN OUT VARCHAR2,
qt_name             IN OUT VARCHAR2,
udata_type          IN OUT NUMBER);
TBD
 
GET_QUEUETABLE_NAME (new 23c)
Undocumented dbms_aqmigtool_sys.get_queuetable_name(
q_schema IN VARCHAR2,
q_name   IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_RULE_NAME (new 23c)
Undocumented dbms_aqmigtool_sys.get_rule_name(
qschema IN VARCHAR2,
qname   IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_TXEVENTQ_MSG_COUNT (new 23c)
Undocumented dbms_aqmigtool_sys.get_txeventq_msg_count(
q_schema   IN VARCHAR2,
q_name     IN VARCHAR2,
only_check IN BOOLEAN)
RETURN NUMBER;
TBD
 
GET_TXEVENTQ_NAME (new 23c)
Undocumented dbms_aqmigtool_sys.get_txeventq_name(
q_schema   IN  VARCHAR2,
q_name     IN  VARCHAR2,
teq_schema OUT VARCHAR2)
RETURN VARCHAR2;
TBD
 
INSERT_MIG_STATUS (new 23c)
Undocumented dbms_aqmigtool_sys.insert_mig_status(
migration_id IN RAW,
s_schema     IN VARCHAR2,
s_queue      IN VARCHAR2,
t_schema     IN VARCHAR2,
t_queue      IN VARCHAR2,
status_p     IN NUMBER,
event        IN VARCHAR2,
event_id_p   IN NUMBER,
event_error  IN VARCHAR2,
ordering     IN VARCHAR2,
suffix       IN VARCHAR2,
mig_mode_p   IN NUMBER,
spare1_p     IN NUMBER);
TBD
 
RECOVER_MIGRATION_INT (new 23c)
Undocumented dbms_aqmigtool_sys.recover_migration_int(
schema     IN  VARCHAR2,
qname      IN  VARCHAR2,
teq_schema OUT VARCHAR2,
teq_queue  OUT VARCHAR2,
event_id_p OUT NUMBER,
phase      OUT NUMBER)
RETURN BOOLEAN;
TBD
 
RENAME_TXEVENTQ_INT (new 23c)
Undocumented dbms_aqmigtool_sys.rename_txeventq_int(
schema       IN VARCHAR2,
qname        IN VARCHAR2,
new_qname    IN VARCHAR2,
is_excep_q   IN BOOLEAN,
current_user IN VARCHAR2);
TBD
 
UPDATE_MIG_STATUS (new 23c)
Undocumented dbms_aqmigtool_sys.update_mig_status(
s_schema   IN VARCHAR2,
s_queue    IN VARCHAR2,
status_p   IN NUMBER,
event_id_p IN NUMBER,
spare1_p   IN NUMBER);
TBD
 
UPDATE_MIG_STATUS_COMMIT (new 23c)
Undocumented dbms_aqmigtool_sys.update_mig_status_commit(
s_schema   IN VARCHAR2,
s_queue    IN VARCHAR2,
status_p   IN NUMBER,
event_id_p IN NUMBER,
spare1_p   IN NUMBER);
TBD
 
UPDATE_MIG_STATUS_QT (new 23c)
Undocumented dbms_aqmigtool_sys.update_mig_status_qt(
s_schema   IN VARCHAR2,
s_queue    IN VARCHAR2,
status_p   IN NUMBER,
event_id_p IN NUMBER,
s_qtname   IN VARCHAR2);
TBD
 
VALIDATE_QUEUE (new 23c)
Undocumented dbms_aqmigtool_sys.validate_queue(
schema IN VARCHAR2,
qname  IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AQADM
DBMS_AQMIGTOOL
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