For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.

Purpose

Export AQ Index 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_index_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;