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

Related Topics
Database Security
Built-in Functions
Built-in Packages
DBMS_AQ
DBMS_AQADM
DBMS_AQADM_INV
DBMS_AQADM_VAR
DBMS_AQELM
DBMS_AQIN
DBMS_AQ_BQVIEW
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_EXP_ZECURITY
DBMS_AQ_IMPORT_INTERNAL
DBMS_AQ_IMP_ZECURITY
DBMS_AQ_SYS_EXP_INTERNAL
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx