Oracle | DBMS_AQ_EXP_HISTORY

Oracle DBMS_AQ_EXP_HISTORY_TABLES Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Export AQ History Tables

AUTHID CURRENT_USER

Dependencies

DBMS_AQ_EXP_ZECURITY

DBMS_AQ_SYS_EXP_ACTIONS

Documented No

First Available Traced back so far to 9i

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvtaqxi.plb

INSTANCE_INFO_EXP

Undocumented dbms_aq_exp_history_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                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 PLS_INTEGER;

       retVal VARCHAR2(120);

      BEGIN

        retVal := dbms_aq_exp_history_tables.instance_info_exp('ALERT_QT', 'SYS', 0, 1, '21.1.0.0.0', nblk);

        dbms_output.put_line('1: ' || retVal);

          dbms_output.put_line('2: ' || TO_CHAR(nblk));

      END;

      /

      1:

      2: 1