Oracle | DBMS_AQ_EXP_DEQUEUELOG

Oracle DBMS_AQ_EXP_DEQUEUELOG_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 Dequeue Log 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_cmt_time_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                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(4096);

      BEGIN

        retVal := dbms_aq_exp_dequeuelog_tables.instance_info_exp('AQ_EVENT_TABLE', '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: DECLARE dbvers varchar2(20); compat varchar2(20); BEGIN execute immediate 'begin sys.DBMS_UTILITY.DB_VERSION(:1, :2); end;' using out dbvers, out compat; IF

      (sys.dbms_logrep_exp.version_var2_2_number(dbvers) >= sys.dbms_logrep_exp.version_var2_2_number('11.2')) THEN execute immediate 'begin

      SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_DEQUEUELOG_TABLE(''AQ_EVENT_TABLE''); end;'; ELSE execute immediate 'ALTER SESSION SET EVENTS ''10851 trace name context forever, level 1''';

      execute immediate 'DROP TABLE "SYS"."AQ_EVENT_TABLE"'; END IF; END;

      

      PL/SQL procedure successfully completed.