Oracle | DBMS_AQ_SYS_EXP

Oracle DBMS_AQ_SYS_EXP_ACTIONS 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 Advanced Queuing Export Utilities

AUTHID DEFINER

Dependencies

ALL_QUEUES	DBMS_AQ_EXP_QUEUES
AQ$_BND_ARRAY	DBMS_AQ_EXP_QUEUE_TABLES
AQ$_INTERNET_AGENTS	DBMS_AQ_EXP_SIGNATURE_TABLES
AQ$_INTERNET_AGENT_PRIVS	DBMS_AQ_EXP_SUBSCRIBER_TABLES
AQ$_QUEUES	DBMS_AQ_EXP_TIMEMGR_TABLES
AQ$_QUEUE_TABLES	DBMS_AQ_SYS_EXP_INTERNAL
AQ$_QUEUE_TABLE_AFFINITIES	DBMS_ASSERT
DBMS_AQADM	DBMS_LOGREP_EXP
DBMS_AQADM_SYS	DBMS_SCHEDULER
DBMS_AQINT_LIB	DBMS_STREAMS_DATAPUMP_UTIL
DBMS_AQ_EXP_CMT_TIME_TABLES	DBMS_SYS_ERROR
DBMS_AQ_EXP_DEQUEUELOG_TABLES	OBJ$
DBMS_AQ_EXP_HISTORY_TABLES	USER$
DBMS_AQ_EXP_INDEX_TABLES

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted

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

Subprograms

EXPORT_AGENTS	EXPORT_QUEUE_SEQUENCE	EXPORT_TABLE
EXPORT_QUEUE_META	EXPORT_QUEUE_SHARDED_TABLE	POST_SCHEMA_CLEANUP

EXPORT_AGENTS

Undocumented dbms_aq_sys_exp_actions.export_agents(schema IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_aq_sys_exp_actions.export_agents('UWCLASS');

      

      DBMS_AQ_SYS_EXP_ACTIONS.EXPORT_AGENTS('UWCLASS')

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

EXPORT_QUEUE_META

Undocumented dbms_aq_sys_exp_actions.export_queue_meta(objid IN NUMBER) RETURN VARCHAR2;

SELECT dbms_aq_sys_exp_actions.export_queue_meta(73005);

      

      DBMS_AQ_SYS_EXP_ACTIONS.EXPORT_QUEUE_META(73005)

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

EXPORT_QUEUE_SEQUENCE

Undocumented dbms_aq_sys_exp_actions.export_queue_sequence(objid IN NUMBER) RETURN VARCHAR2;

SELECT dbms_aq_sys_exp_actions.export_queue_sequence(73005);

      

      
      DBMS_AQ_SYS_EXP_ACTIONS.EXPORT_QUEUE_SEQUENCE(73005)

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

EXPORT_QUEUE_SHARDED_TABLE

Undocumented dbms_aq_sys_exp_actions.export_queue_sharded_table( table_schema IN VARCHAR2, table_name IN VARCHAR2, version IN VARCHAR2, prepost IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

EXPORT_TABLE

Undocumented dbms_aq_sys_exp_actions( name IN VARCHAR2, schema IN VARCHAR2, prepost IN BINARY_INTEGER, type IN BINARY_INTEGER, version IN VARCHAR2) RETURN VARCHAR2;

TBD

POST_SCHEMA_CLEANUP

Undocumented dbms_aq_sys_exp_actions(schema IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_aq_sys_exp_actions.post_schema_cleanup('SCOTT');

      

      DBMS_AQ_SYS_EXP_ACTIONS.POST_SCHEMA_CLEANUP('SCOTT')

      ----------------------------------------------------SYS.DBMS_AQ_IMP_INTERNAL.CLEANUP_SCHEMA_IMPORT;

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated: