Oracle | DBMS_AQ_EXP_TIMEMGR

Oracle DBMS_AQ_EXP_TIMEMGR_TABLES 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 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.3.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');;