Oracle | DBMS_AQ_SYS_EXP

Oracle DBMS_AQ_SYS_EXP_ACTIONS Version 21c

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