Oracle | DBMS_PRVTAQIM

Oracle DBMS_PRVTAQIM Version 21c

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 Advanced Queuing Utilities (a substantial percentage of the subprograms are likely deprecated)

AUTHID DEFINER

Dependencies

ALL_OBJECTS	DBA_TABLESPACES	DBMS_LOGREP_UTIL
ALL_TYPES	DBA_USERS	DBMS_PRVTAQIS
ALL_USERS	DBMS_AQ	DBMS_SQL
AQ$_AGENT	DBMS_AQADM	DBMS_STATS_INTERNAL
AQ$BND	DBMS_AQADM_INV	DBMS_SYSTEM
AQ$BIND_ARRAY	DBMS_AQADM_LIB	DBMS_SYS_ERROR
AQ$_DEQUEUE_HISTORY	DBMS_AQADM_SYS	DBMS_TRANSACTION
AQ$_HISTORY	DBMS_AQADM_SYSCALLS	DBMS_UTILITY
AQ$_QUEUES	DBMS_AQADM_VAR	DUAL
AQ$_QUEUE_TABLES	DBMS_AQINT_LIB	OBJ$
COL$	DBMS_AQ_IMPORT_INTERNAL	PLITBLM
COLTYPE$	DBMS_AQ_IMPORT_INTERNAL_DR	PROPS$
DBA_INDEXES	DBMS_AQ_SYS_EXP_INTERNAL	USER$
DBA_OBJECTS	DBMS_AQ_SYS_IMP_INTERNAL	V$PARAMETER
DBA_TABLES	DBMS_ASSERT

Documented No

Exceptions

Error Code	Reason
ORA-14133	ALTER TABLE MOVE cannot be combined with other operations
ORA-24005	Inappropriate utilities used to perform DDL on AQ table <schema_name>.<table_name>

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmsaqds.plb
{ORACLE_HOME}/rdbms/admin/prvtaqim.plb

a18.sql & f18.sql
a1102000.sql & f1102000.sql
a1201000.sql & f1201000.sql
f1202000.sql

Subprograms

AQ_PATCH_CMT_TIME	CREATE_BASE_VIEW_12101	DOWNGRADE_QUEUE_TABLE
AQ_PATCH_DEQUEUELOG_TABLE	CREATE_BASE_VIEW_12C	DROP_COMMIT_TIME_IOT
AQ_PATCH_HISTORY	CREATE_BASE_VIEW_12C_12201	DROP_DEQUEUE_IOT
AQ_PATCH_IOT	CREATE_BASE_VIEW_12C_18	DROP_DEQUEUE_LOG
AQ_PATCH_SIGNATURE	CREATE_COMMIT_TIME_IOT	DROP_HISTORY_IOT
AQ_PATCH_TIMEMGR	CREATE_DEQUEUE_IOT	DROP_QUEUE
BUFQ_VIEW_PARAMS	CREATE_DEQUEUE_LOG	DROP_SIGNATURE_IOT
COMPRESS_IOT	CREATE_DEQ_VIEW	DROP_TIMEMGMT_IOT
CREATE_BASE_VIEW	CREATE_DEQ_VIEW_PRE11_2	UNCOMPRESS_IOT
CREATE_BASE_VIEW10_1_0	CREATE_HISTORY_IOT	UPDATE_IOT_MSG_ROWID
CREATE_BASE_VIEW11_1_0	CREATE_SIGNATURE_IOT	UPGRADE_QUEUE_TABLE
CREATE_BASE_VIEW11_2_0	CREATE_TIMEMGMT_IOT	USER_DATA_COL

AQ_PATCH_CMT_TIME

Undocumented dbms_prvtaqim.aq_patch_cmt_time( schema IN VARCHAR2, iot IN VARCHAR2, qt_name IN VARCHAR2);

TBD

AQ_PATCH_DEQUEUELOG_TABLE

Undocumented dbms_prvtaqim.aq_patch_dequeuelog_table( schema IN VARCHAR2, dequeuelog IN VARCHAR2, queue_table IN VARCHAR2);

TBD

AQ_PATCH_HISTORY

Undocumented dbms_prvtaqim.aq_patch_history( schema IN VARCHAR2, iot IN VARCHAR2, qt_name IN VARCHAR2, commit_frequency IN NUMBER);

TBD

AQ_PATCH_IOT

Undocumented dbms_prvtaqim.aq_patch_iot( schema IN VARCHAR2, iot IN VARCHAR2, qt_name IN VARCHAR2, commit_frequency IN NUMBER);

TBD

AQ_PATCH_SIGNATURE

Undocumented dbms_prvtaqim.aq_patch_signature( schema IN VARCHAR2, iot IN VARCHAR2, qt_name IN VARCHAR2, commit_frequency IN NUMBER);

TBD

AQ_PATCH_TIMEMGR

Undocumented dbms_prvtaqim.aq_patch_timemgr( schema IN VARCHAR2, iot IN VARCHAR2, qt_name IN VARCHAR2);

TBD

BUFQ_VIEW_PARAMS

Undocumented dbms_prvtaqim.bufq_view_params( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER, bufq_cols OUT VARCHAR2, bufq_from OUT VARCHAR2, spill_cols OUT VARCHAR2, spill_from OUT VARCHAR2);

TBD

COMPRESS_IOT

Undocumented dbms_prvtaqim.compress_iot( schema IN VARCHAR2, qt_name IN VARCHAR2);

SELECT schema, name

      FROM system.aq$_queue_tables

      ORDER BY 1,2;

      

      SCHEMA              NAME

      ----------------- ------------------------------

      GSMADMIN_INTERNAL CHANGE_LOG_QUEUE_TABLE

      SYS               ALERT_QT

      SYS               AQ$_MEM_MC

      SYS               AQ_EVENT_TABLE

      SYS               AQ_PROP_TABLE

      SYS               AQ_SRVNTFN_TABLE_1

      SYS               CQN_EVENT_TABLE

      SYS               KUPC$DATAPUMP_QUETAB_1

      SYS               MGW_JMS_RECV_LOG_QT

      SYS               MGW_JMS_SEND_LOG_QT

      SYS               MGW_NOTIFY_QUEUE_QT

      SYS               MGW_RECV_LOG_QT

      SYS               MGW_SEND_LOG_QT

      SYS               ORA$PREPLUGIN_BACKUP_QTB

      SYS               PDB_MON_EVENT_QTABLE$

      SYS               SCHEDULER$_EVENT_QTAB

      SYS               SCHEDULER$_REMDB_JOBQTAB

      SYS               SCHEDULER_FILEWATCHER_QT

      SYS               SYS$SERVICE_METRICS_TAB

      WMSYS             WM$EVENT_QUEUE_TABLE

      

      exec sys.dbms_prvtaqim.uncompress_iot('SYS', 'ALERT_QT');

      BEGIN sys.dbms_prvtaqim.compress_iot('SYS', 'PDB_MON_EVENT_QTABLE$'); END;

            *

      ERROR at line 1:

      ORA-24005: Inappropriate utilities used to perform DDL on AQ table SYS.AQ$_PDB_MON_EVENT_QTABLE$_I

      ORA-06512: at "SYS.DBMS_PRVTAQIM", line 2834

      ORA-06512: at line 1

CREATE_BASE_VIEW

Undocumented dbms_prvtaqim.create_base_view( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

CREATE_BASE_VIEW10_1_0

Undocumented dbms_prvtaqim.create_base_view10_1_0( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

CREATE_BASE_VIEW11_1_0

Undocumented dbms_prvtaqim.create_base_view11_1_0( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

CREATE_BASE_VIEW11_2_0

Undocumented dbms_prvtaqim.create_base_view11_2_0( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

CREATE_BASE_VIEW_12101

Undocumented dbms_prvtaqim.create_base_view_12101( q_schema IN VARCHAR2, q_name IN VARCHAR2, queue_objno IN NUMBER, isjmsq IN BOOLEAN);

TBD

CREATE_BASE_VIEW_12C

Undocumented dbms_prvtaqim.create_base_view_12c( q_schema IN VARCHAR2, q_name IN VARCHAR2, queue_objno IN NUMBER, isjmsq IN BOOLEAN, qt_flags IN NUMBER);

TBD

CREATE_BASE_VIEW_12C_12201

Undocumented dbms_prvtaqim.create_base_view_12c_12201( q_schema IN VARCHAR2, q_name IN VARCHAR2, queue_objno IN NUMBER, isjmsq IN BOOLEAN, qt_flags IN NUMBER);

TBD

CREATE_BASE_VIEW_12C_18

Undocumented dbms_prvtaqim.create_base_view_12c_18( q_schema IN VARCHAR2, q_name IN VARCHAR2, queue_objno IN NUMBER, isjmsq IN BOOLEAN, qt_flags IN NUMBER);

TBD

CREATE_COMMIT_TIME_IOT

Undocumented dbms_prvtaqim.create_commit_time_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

CREATE_DEQUEUE_IOT

Undocumented dbms_prvtaqim.create_dequeue_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER, sort_list IN VARCHAR2, temporary IN BOOLEAN, ignore_ddl_error IN BOOLEAN, key_compression IN BOOLEAN)

TBD

CREATE_DEQUEUE_LOG

Undocumented dbms_prvtaqim.create_dequeue_log( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER, ignore_ddl_error IN BOOLEAN);

TBD

CREATE_DEQ_VIEW

Undocumented dbms_prvtaqim.create_deq_view( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

CREATE_DEQ_VIEW_PRE11_2

Undocumented dbms_prvtaqim.create_deq_view_pre11_2( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

CREATE_HISTORY_IOT

Undocumented dbms_prvtaqim.create_history_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER, ignore_ddl_error IN BOOLEAN, key_compression IN BOOLEAN);

TBD

CREATE_SIGNATURE_IOT

Undocumented dbms_prvtaqim.create_signature_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN, key_compression IN BOOLEAN);

TBD

CREATE_TIMEMGMT_IOT

Undocumented dbms_prvtaqim.create_timemgmt_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DOWNGRADE_QUEUE_TABLE

Undocumented dbms_prvtaqim.downgrade_queue_table( schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER, current_user IN VARCHAR2);

TBD

DROP_COMMIT_TIME_IOT

Undocumented dbms_prvtaqim.drop_commit_time_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DROP_DEQUEUE_IOT

Undocumented dbms_prvtaqim.drop_dequeue_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DROP_DEQUEUE_LOG

Undocumented dbms_prvtaqim.drop_dequeue_log( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DROP_HISTORY_IOT

Undocumented dbms_prvtaqim.drop_history_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DROP_QUEUE

Undocumented dbms_prvtaqim.drop_queue( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, q_name IN VARCHAR2, qt_flags IN NUMBER);

TBD

DROP_SIGNATURE_IOT

Undocumented dbms_prvtaqim.drop_signature_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

DROP_TIMEMGMT_IOT

Undocumented dbms_prvtaqim.drop_timemgmt_iot( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, ignore_ddl_error IN BOOLEAN);

TBD

UNCOMPRESS_IOT

Undocumented dbms_prvtaqim.uncompress_iot( schema IN VARCHAR2, qt_name IN VARCHAR2);

exec dbms_prvtaqim.uncompress_iot('SYS', 
      'ALERT_QT');

      BEGIN sys.dbms_prvtaqim.uncompress_iot('SYS', 'ALERT_QT'); END;

            *

      ERROR at line 1:

      ORA-14133: ALTER TABLE MOVE cannot be combined with other operations

      ORA-06512: at "SYS.DBMS_PRVTAQIM", line 2859

      ORA-06512: at line 1

UPDATE_IOT_MSG_ROWID

Undocumented dbms_prvtaqim.update_iot_msg_rowid( schema IN VARCHAR2, iot IN VARCHAR2, qt_name IN VARCHAR2, commit_frequency IN NUMBER);

TBD

UPGRADE_QUEUE_TABLE

Undocumented dbms_prvtaqim.upgrade_queue_table( schema IN VARCHAR2, qt_name IN VARCHAR2, qt_flags IN NUMBER, current_user IN VARCHAR2);

TBD

USER_DATA_COL

Undocumented dbms_prvtaqim.user_data_col( qt_schema IN VARCHAR2, qt_name IN VARCHAR2) RETURN VARCHAR2;

TBD