Oracle | DBMS_AQ_EXP

Oracle DBMS_AQ_EXP_QUEUES 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 Advanced Queuing Export Tables Management

AUTHID CURRENT_USER

Dependencies

DBMS_AQADM_SYS	DBMS_AQ_SYS_EXP_INTERNAL	OBJ$
DBMS_AQ_EXP_ZECURITY	DBMS_AQ_SYS_IMP_INTERNAL	USER$
DBMS_AQ_SYS_EXP_ACTIONS	DBMS_ZHELP_IR

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/

Subprograms

AUDIT_EXP	CREATE_EXP	GRANT_EXP
AUDIT_SYSPRIVS_EXP	DROP_EXP	GRANT_SYSPRIVS_EXP

AUDIT_EXP

Undocumented dbms_aq_exp_queues.audit_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

AUDIT_SYSPRIVS_EXP

Undocumented dbms_aq_exp_queues.audit_sysprivs_exp( version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       outVal BINARY_INTEGER;

       retVal VARCHAR2(60);

      BEGIN

        retVal := dbms_aq_exp_queues.audit_sysprivs_exp('3', outVal);

        dbms_output.put_line(outVal);

        dbms_output.put_line(retVal);

      END;

      /

      

      PL/SQL procedure successfully completed.

CREATE_EXP

Undocumented dbms_aq_exp_queues.create_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

DROP_EXP

Undocumented dbms_aq_exp_queues.drop_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

GRANT_EXP

Undocumented dbms_aq_exp_queues.grant_exp( objid IN NUMBER, isdba IN BINARY_INTEGER, grantor OUT VARCHAR2, version IN VARCHAR2, new_bloc OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

GRANT_SYSPRIVS_EXP

Undocumented dbms_aq_exp_queues.grant_sysprivs_exp( version IN VARCHAR2 new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       outVal BINARY_INTEGER;

       retVal VARCHAR2(600);

      BEGIN

        retVal := dbms_aq_exp_queues.grant_sysprivs_exp('23', outVal);

        dbms_output.put_line(outVal);

        dbms_output.put_line(retVal);

      END;

      /

      1

      SYS.DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE('MANAGE_ANY','"SYSTEM"',TRUE);

      

      PL/SQL procedure successfully completed.