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
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;