Oracle | DBMS_AQ_IMPORT_INTERNAL

Oracle DBMS_AQ_IMPORT_INTERNAL_DR 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 for Data Guard Physical Standby

AUTHID DEFINER

Dependencies

ALL_OBJECTS	DBMS_AQADM_SYSCALLS	DBMS_PRVTAQIS
AQ$_AGENT	DBMS_AQINT_LIB	DBMS_SYSTEM
AQ$_QUEUES	DBMS_AQ_IMPORT_INTERNAL	DBMS_SYS_ERROR
AQ$_QUEUE_TABLES	DBMS_ASSERT	DBMS_UTILITY
AQ$_QUEUE_TABLE_AFFINITIES	DBMS_PRVTAQIM	EXPACT$
DBMS_AQADM_SYS

Documented No

First Available 18c

Security Model Owned by SYS with no privileges granted

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