Oracle DBMS_PRVTAQIM
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AQ
DBMS_AQADM
DBMS_PRVTAQIP
DBMS_SCHEDULER
What's New In 19c
What's New In 20c-21c

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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx