General Information
Library Note
Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx .
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;