Oracle DBMS_AQ_SYS_EXP_ACTIONS
Version 20c

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 Note: This page has been posted prior to the GA release of 20c. It will be completed once we have access to the release version.
AUTHID DEFINER
Dependencies
ALL_QUEUES 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$
DBMS_AQINT_LIB DBMS_AQ_EXP_TIMEMGR_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
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
What's New In 19c
What's New In 20c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx