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.
dbms_aqmigtool_sys.check_unsupport_feature(
qschema IN VARCHAR2,
qname IN VARCHAR2,
event OUT VARCHAR2,
eventerr OUT VARCHAR2,
warningcheck IN BOOLEAN)
RETURN BOOLEAN;
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);
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);
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);
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);
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);
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;
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);