Oracle | DBMS_AQ_SYS_EXP

Oracle DBMS_AQ_SYS_EXP_ACTIONS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Advanced Queuing Export Utilities

AUTHID DEFINER

Dependencies

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

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')

      FROM dual;

      

      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)

      FROM dual;

      

      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)

      FROM dual;

      

      
      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')

      FROM dual;

      

      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 Dan Morgan. Last Updated:

DBSecWorx