Oracle | DBMS_PRVTAQIM

Oracle DBMS_PRVTAQIM Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Advanced Queuing Utilities (a substantial percentage of the subprograms are likely deprecated)

AUTHID DEFINER

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_PRVTAQIM' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_PRVTAQIM' ORDER BY 1;

Returns 457 objects

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

Subprograms

AQ_PATCH_CMT_TIME	CREATE_BASE_VIEW_12C	DOWNGRADE_QUEUE_TABLE
AQ_PATCH_DEQUEUELOG_TABLE	CREATE_BASE_VIEW_12C_12201	DROP_COMMIT_TIME_IOT
AQ_PATCH_HISTORY	CREATE_BASE_VIEW_12C_18	DROP_DEQUEUE_IOT
AQ_PATCH_IOT	CREATE_BASE_VIEW_12C_21	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
CREATE_BASE_VIEW_12101

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');

      *

      ERROR at line 1:

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

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_BASE_VIEW_12C_21 (new 23ai)

Undocumented dbms_prvtaqim.create_base_view_12c_21( 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');

      *

      ERROR at line 1:

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

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