Oracle DBMS_AQ_EXP_TIMEMGR_TABLES
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 Export AQ Time Manager Tables
AUTHID CURRENT_USER
Dependencies
DBMS_AQ_EXP_ZECURITY DBMS_AQ_SYS_EXP_ACTIONS  
Documented No
First Available 11.2
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
 
INSTANCE_INFO_EXP
Undocumented dbms_aq_exp_timemgr_tables(
name      IN  VARCHAR2,
schema    IN  VARCHAR2,
prepost   IN  BINARY_INTEGER,
isdba     IN  BINARY_INTEGER,
version   IN  VARCHAR2,
new_block OUT BINARY_INTEGER)
RETURN VARCHAR2;
SELECT owner, queue_table, type
FROM dba_queue_tables
ORDER BY 1,2;

OWNER                     QUEUE_TABLE                    TYPE
------------------------- ------------------------------ -------
GSMADMIN_INTERNAL         CHANGE_LOG_QUEUE_TABLE         OBJECT
SYS                       ALERT_QT                       OBJECT
SYS                       AQ$_MEM_MC                     RAW
SYS                       AQ_EVENT_TABLE                 OBJECT
SYS                       AQ_PROP_TABLE                  OBJECT
SYS                       CQN_EVENT_TABLE                OBJECT
SYS                       MGW_JMS_RECV_LOG_QT            OBJECT
SYS                       MGW_JMS_SEND_LOG_QT            OBJECT
SYS                       MGW_NOTIFY_QUEUE_QT            OBJECT
SYS                       MGW_RECV_LOG_QT                RAW
SYS                       MGW_SEND_LOG_QT                RAW
SYS                       ORA$PREPLUGIN_BACKUP_          QTB OBJECT
SYS                       PDB_MON_EVENT_QTABLE$          OBJECT
SYS                       SCHEDULER$_EVENT_QTAB          OBJECT
SYS                       SCHEDULER$_REMDB_JOBQTAB       OBJECT
SYS                       SCHEDULER_FILEWATCHER_QT       OBJECT
SYS                       SYS$SERVICE_METRICS_TAB        OBJECT
WMSYS                     WM$EVENT_QUEUE_TABLE           OBJECT


set serveroutput on

DECLARE
 nblk   BINARY_INTEGER;
 retVal dbms_id;
BEGIN
  retVal := dbms_aq_exp_timemgr_tables.instance_info_exp('ALERT_QT OBJECT', 'SYS', 1, 1, '21.1.0.0.0', nblk);
  dbms_output.put_line('New Block: ' || TO_CHAR(nblk));
  dbms_output.put_line('Return Value: ' || retVal);
END;
/
New Block: 1
Return Value: SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_TIMEMGR_TABLE('ALERT_QT OBJECT');;

Related Topics
Advanced Queuing Demo 1
Advanced Queuing RAC Demo
Built-in Functions
Built-in Packages
DBMS_AQ
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_SYS_EXP_ACTIONS
DBMS_AQ_SYS_EXP_INTERNAL
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx