Oracle | DBMS_AQ_EXP_CMT_TIME

Oracle DBMS_AQ_EXP_CMT_TIME_TABLES Version 23c

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 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.2.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.