Oracle DBMS_AQ_IMPORT_INTERNAL_DR
Version 19.3

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 (new 19c)
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 (new 19c)
Undocumented dbms_aq_import_internal.aq_export_check(arg_list IN VARCHAR2) RETURN VARCHAR2;
TBD
 
AQ_EXPORT_IOT (new 19c)
Undocumented dbms_aq_import_internal.aq_export_iot(arg_list IN VARCHAR2) RETURN VARCHAR2;
TBD
 
AQ_EXPORT_SUBSCRIBER (new 19c)
Undocumented dbms_aq_import_internal.aq_export_subscriber(arg_list IN VARCHAR2) RETURN VARCHAR2;
TBD
 
AQ_IMPORT_IOT (new 19c)
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 (new 19c)
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 (new 19c)
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 (new 19c)
Undocumented dbms_aq_import_internal.aq_table_export_check(arg_list IN VARCHAR2) RETURN VARCHAR2;
TBD
 
CREATE_EXPACT_ENTRY (new 19c)
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 (new 19c)
Undocumented dbms_aq_import_internal.remove_expact_entry(

obj_owner     IN VARCHAR2,
obj_name      IN VARCHAR2,
user_argument IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_ALERT
DBMS_AQ
DBMS_AQADM
DBMS_AQADM_INV
DBMS_AQADM_VAR
DBMS_AQELM
DBMS_AQIN
DBMS_AQ_BQVIEW
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_EXP_ZECURITY
DBMS_AQ_IMP_ZECURITY
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx