Oracle | DBMS_AQ_SYS_EXP

Oracle DBMS_AQ_SYS_EXP_INTERNAL 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 Undocumented

AUTHID DEFINER

Dependencies

AQ$_DEQUEUE_LOG_PARTITION_MAP	DBMS_AQINT_LIB	DBMS_PRVTAQIS
AQ$_DURABLE_SUBS	DBMS_AQ_EXP_QUEUES	DBMS_PRVTSQDS
AQ$_QUEUES	DBMS_AQ_EXP_QUEUE_TABLES	DBMS_STREAMS_DATAPUMP_UTIL
AQ$_QUEUE_PARTITION_MAP	DBMS_AQ_EXP_ZECURITY	DBMS_SYSTEM
AQ$_QUEUE_SHARDS	DBMS_AQ_IMPORT_INTERNAL	DBMS_SYS_ERROR
AQ$_QUEUE_TABLES	DBMS_AQ_SYS_EXP_ACTIONS	DBMS_ZHELP
AQ$_QUEUE_TABLE_AFFINITIES	DBMS_AQ_SYS_IMP_INTERNAL	EXPDEPACT$
DBA_OBJECTS	DBMS_ASSERT	EXPDEPOBJ$
DBA_SEQUENCES	DBMS_LOB	OBJ$
DBMS_AQADM_SYS	DBMS_LOGREP_EXP	USER$
DBMS_AQADM_SYSCALLS	DBMS_PRVTAQIM

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtaqxi.plb
{ORACLE_HOME}/rdbms/admin/dbmsaqds.plb
{ORACLE_HOME}/rdbms/admin/prvtaqxe.plb

Subprograms

APPENDBUF	EXPORT_QUEUE_PRIVILEGE	POPULATE_TTS_SUB
COUNT_AQ_OBJECTS	EXPORT_QUEUE_TABLE	REGISTER_PROCEDURAL_ACTION
DEREGISTER_PROCEDURAL_ACTION	EXPORT_SYSTEM_PRIVILEGE	REGISTER_PROCEDURAL_OBJECT
DEREGISTER_PROCEDURAL_OBJECT	POPULATE_TTS_DQMAP	TO_OWNERID
DOWNGRADE_EXPORT_ACTIONS	POPULATE_TTS_QTMAP	UPGRADE_EXPORT_ACTIONS
EXPORT_QUEUE	POPULATE_TTS_SHARDS

APPENDBUF

Undocumented dbms_aq_sys_exp_internal.appendbuf( target IN OUT VARCHAR2, source IN VARCHAR2, lobpos IN OUT NUMBER);

TBD

COUNT_AQ_OBJECTS

Undocumented dbms_aq_sys_exp_internal.count_aq_objects(schema IN VARCHAR2) RETURN NUMBER;

SELECT dbms_aq_sys_exp_internal.count_aq_objects(USER) 
      FROM dual;

      

      DBMS_AQ_SYS_EXP_INTERNAL.COUNT_AQ_OBJECTS(USER)

      -----------------------------------------------

                                                   63

DEREGISTER_PROCEDURAL_ACTION

Undocumented

Overload 1 dbms_aq_sys_exp_internal.deregister_procedural_action(objid IN NUMBER);

TBD

Overload 2 dbms_aq_sys_exp_internal.deregister_procedural_action( table_name IN VARCHAR2, table_schema IN VARCHAR2);

TBD

DEREGISTER_PROCEDURAL_OBJECT

Undocumented dbms_aq_sys_exp_internal.deregister_procedural_object(dep_objid IN NUMBER);

TBD

DOWNGRADE_EXPORT_ACTIONS

Undocumented dbms_aq_sys_exp_internal.downgrade_export_actions( table_name IN VARCHAR2, table_schema IN VARCHAR2);

TBD

EXPORT_QUEUE

Undocumented dbms_aq_sys_exp_internal.export_queue(objid IN NUMBER) RETURN VARCHAR2;

TBD

EXPORT_QUEUE_PRIVILEGE

Undocumented dbms_aq_sys_exp_internal.export_queue_privilege( objid IN NUMBER, isdba IN BINARY_INTEGER, grantor OUT VARCHAR2) RETURN VARCHAR2;

TBD

EXPORT_QUEUE_TABLE

Undocumented dbms_aq_sys_exp_internal.export_queue_table( table_schema IN VARCHAR2, table_name IN VARCHAR2, version IN VARCHAR2) RETURN VARCHAR2;

TBD

EXPORT_SYSTEM_PRIVILEGE

Undocumented dbms_aq_sys_exp_internal.export_system_privilege RETURN VARCHAR2;

SELECT dbms_aq_sys_exp_internal.export_system_privilege

      FROM dual;

POPULATE_TTS_DQMAP

Undocumented dbms_aq_sys_exp_internal.populate_tts_dqmap( objid IN NUMBER, firstblock IN OUT BOOLEAN) RETURN VARCHAR2;

TBD

POPULATE_TTS_QTMAP

Undocumented dbms_aq_sys_exp_internal.populate_tts_qtmap( objid IN NUMBER, firstblock IN OUT BOOLEAN) RETURN VARCHAR2;

TBD

POPULATE_TTS_SHARDS

Undocumented dbms_aq_sys_exp_internal.populate_tts_shards( objid IN NUMBER, firstblock IN OUT BOOLEAN) RETURN VARCHAR2;

TBD

POPULATE_TTS_SUB

Undocumented dbms_aq_sys_exp_internal.populate_tts_sub( objid IN NUMBER, firstblock IN OUT BOOLEAN) RETURN VARCHAR2;

TBD

REGISTER_PROCEDURAL_ACTION

Undocumented

Overload 1 dbms_aq_sys_exp_internal.register_procedural_action( objid IN NUMBER, package IN VARCHAR2, package_schema IN VARCHAR2);

TBD

Overload 2 dbms_aq_sys_exp_internal.register_procedural_action( table_name IN VARCHAR2, table_schema IN VARCHAR2, package IN VARCHAR2, package_schema IN VARCHAR2);

TBD

REGISTER_PROCEDURAL_OBJECT

Undocumented dbms_aq_sys_exp_internal.register_procedural_object( dep_objid IN NUMBER, parent_objid IN NUMBER);

TBD

TO_OWNERID

Undocumented dbms_aq_sys_exp_internal.to_ownerid(objid IN NUMBER) RETURN NUMBER;

TBD

UPGRADE_EXPORT_ACTIONS

Undocumented dbms_aq_sys_exp_internal.upgrade_export_actions( table_name IN VARCHAR2, table_schema IN VARCHAR2)

TBD