Oracle | DBMS_AQ_IMPORT

Oracle DBMS_AQ_IMPORT_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 Advanced Queuing Import Utilities

AUTHID CURRENT_USER

Dependencies

DBMS_AQADM_SYS	DBMS_AQ_SYS_EXP_INTERNAL	DBMS_PRVTAQIS
DBMS_AQ_IMPORT_INTERNAL_DR	DBMS_PRVTAQIM	DBMS_UTILITY

Documented No

First Available 18c

Security Model Owned by SYS with EXECUTE granted to SYSTEM and the EXECUTE_CATALOG_ROLE, EXP_FULL_DATABASE, IMP_FULL_DATABASE and AQ_ADMINISTRATOR_ROLE roles

Source {ORACLE_HOME}/rdbms/admin/dbmsaq8x.plb

Subprograms

AQ_DEFN_UPDATE	AQ_IMPORT_IOT	AQ_TABLE_EXPORT_CHECK
AQ_EXPORT_CHECK	AQ_IMPORT_SUBSCRIBER	CREATE_EXPACT_ENTRY
AQ_EXPORT_IOT	AQ_TABLE_DEFN_UPDATE	REMOVE_EXPACT_ENTRY
AQ_EXPORT_SUBSCRIBER

AQ_DEFN_UPDATE

Updates the definition of a queue dbms_aq_import_internal.aq_defn_update( oid IN RAW, q_schema IN VARCHAR2, qt_name IN VARCHAR2, q_name IN VARCHAR2, q_type IN NUMBER, max_retries IN NUMBER, retry_delay IN NUMBER, q_flags IN NUMBER, retention IN NUMBER, comment IN VARCHAR2);

TBD

AQ_EXPORT_CHECK

Undocumented dbms_aq_import_internal.aq_export_check(arg_list IN VARCHAR2) RETURN VARCHAR2;

TBD

AQ_EXPORT_IOT

Undocumented dbms_aq_import_internal.aq_export_iot(arg_list IN VARCHAR2) RETURN VARCHAR2;

TBD

AQ_EXPORT_SUBSCRIBER

Undocumented dbms_aq_import_internal.aq_export_subscriber(arg_list IN VARCHAR2) RETURN VARCHAR2;

TBD

AQ_IMPORT_IOT

Undocumented dbms_aq_import_internal.aq_import_iot( schema IN VARCHAR2, qt_name IN VARCHAR2, iot IN VARCHAR2);

TBD

AQ_IMPORT_SUBSCRIBER

Undocumented dbms_aq_import_internal.aq_import_subscriber( queue_name IN VARCHAR2, sub_name IN VARCHAR2, sub_dest IN VARCHAR2, sub_pro IN VARCHAR2);

TBD

AQ_TABLE_DEFN_UPDATE

Undocumented

Overload 1 dbms_aq_import_internal.aq_table_defn_update( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, udata IN NUMBER, qt_flags IN NUMBER, sort_cols IN NUMBER, primary_instance IN BINARY_INTEGER, secondary_instance IN BINARY_INTEGER, comment IN VARCHAR2, timezone IN VARCHAR2);

TBD

Overload 2 dbms_aq_import_internal.aq_table_defn_update( qt_schema IN VARCHAR2, qt_name IN VARCHAR2, udata IN NUMBER, qt_flags IN NUMBER, sort_cols IN NUMBER, comment IN VARCHAR2);

TBD

AQ_TABLE_EXPORT_CHECK

Undocumented dbms_aq_import_internal.aq_table_export_check(arg_list IN VARCHAR2) RETURN VARCHAR2;

TBD

CREATE_EXPACT_ENTRY

Undocumented dbms_aq_import_internal.create_expact_entry( obj_owner IN VARCHAR2, obj_name IN VARCHAR2, func_proc IN VARCHAR2, call_rder IN NUMBER, argument_list IN VARCHAR2);

TBD

REMOVE_EXPACT_ENTRY

Undocumented dbms_aq_import_internal.remove_expact_entry( obj_owner IN VARCHAR2, obj_name IN VARCHAR2, user_argument IN VARCHAR2);

TBD