Oracle | DBMS_AQ_EXP_SUBSCRIBER

Oracle DBMS_AQ_EXP_SUBSCRIBER_TABLES Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Export AQ Subscriber 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_subscriber_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

      WHERE rownum < 6

      ORDER BY 1,2;

      

      OWNER              QUEUE_TABLE               TYPE

      ------------------ ------------------------- -----

      GSMADMIN_INTERNAL  CHANGE_LOG_QUEUE_TABLE    OBJECT

      SYS                CQN_EVENT_TABLE           OBJECT

      SYS                ORA$PREPLUGIN_BACKUP_QTB  OBJECT

      SYS                PDB_MON_EVENT_QTABLE$     OBJECT

      WMSYS              WM$EVENT_QUEUE_TABLE      OBJECT

      

      set serveroutput on

      

      DECLARE

       nblk   BINARY_INTEGER;

       retVal VARCHAR2(128);

      BEGIN

        retVal := dbms_aq_exp_subscriber_tables.instance_info_exp('PDB_MON_EVENT_QTABLE$', 'SYS', 1, 1, '23.8.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: 
      SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_SUBSCRIBER_TABLE('PDB_MON_EVENT_QTABLE$');

      

      PL/SQL procedure successfully completed.