Oracle | DBMS_AQ_IMPORT_INTERNAL

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