Oracle | DBMS_AQ_EXP_CMT_TIME

Oracle DBMS_AQ_EXP_CMT_TIME_TABLES Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Export AQ CMT Time Tables

AUTHID CURRENT_USER

Dependencies

DBMS_AQ_EXP_ZECURITY

DBMS_AQ_SYS_EXP_ACTIONS

Documented No

First Available 10.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_cmt_time_tables.instance_info_exp( 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_SESND_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 VARCHAR2(128);

      BEGIN

        retVal := dbms_aq_exp_cmt_time_tables.instance_info_exp('ALERT_QT', 'SYS', 1, 1, '23.4.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:

      

      PL/SQL procedure successfully completed.