Oracle | DBMS_AQMIGTOOL

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 TBD

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	GET_CQ_NAME
CHECK_CURRENT_COMPATIBILITY	GET_PARAM_CREATE_TXEVENTQ
CHECK_N_CLEAN_MIGRATION_INT	GET_QUEUETABLE_NAME
CHECK_UNSUPPORT_FEATURE	GET_RULE_NAME
CLEAR_UNSUPPORTED_FEAT_TABLE_INT	GET_TXEVENTQ_MSG_COUNT
COPY_MSG_TXEVENTQ_TO_CQ	GET_TXEVENTQ_NAME
COPY_OBJECT_PRIVILEGES	INSERT_MIG_STATUS
COPY_PLSQL_NOTIFICATION	RECOVER_MIGRATION_INT
CREATE_EXCEPTION_QUEUE	RENAME_TXEVENTQ_INT
CREATE_MIG_CLEANUP_JOB	UPDATE_MIG_STATUS
DELETE_MIG_STATUS	UPDATE_MIG_STATUS_COMMIT
GENERATE_MID	UPDATE_MIG_STATUS_QT
GENERATE_MIGRATION_REPORT	VALIDATE_QUEUE
GET_CQ_MSG_COUNT

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