Oracle | DBMS_AQ_EXP_DEQUEUELOG

Oracle DBMS_AQ_EXP_DEQUEUELOG_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 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, '21.1.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.