Oracle | DBMS_AQ_SYS_EXP

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