Oracle | DBMS_AQ_EXP_TIMEMGR

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