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
CURRENT_USER
Dependencies
DBMS_AQ_IMP_ZECURITY
DBMS_STREAMS_DATAPUMP_UTIL
SH$QTAB_PMAP_LIST
DBMS_AQ_SYS_IMP_INTERNAL
DBMS_SYS_ERROR
SH$SHARD_META_LIST
DBMS_LOGREP_UTIL
SH$DEQ_PMAP_LIST
SH$SUB_META_LIST
Documented
No
First Available
Not known
Security Model
Owned by SYS with EXECUTE granted to PUBLIC
Direct access to this package is prevented by means of an Accessible By clause.
dbms_aq_imp_internal.bump_tid_sequence(minval IN NUMBER);
exec dbms_aq_imp_internal.bump_tid_sequence(1);
BEGIN dbms_aq_imp_internal.bump_tid_sequence(1); END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 581
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 616
ORA-06512: at "SYS.DBMS_AQ_IMP_INTERNAL", line 197
ORA-06512: at line 1
dbms_aq_imp_internal.import_queue(
oid IN RAW,
queue_table IN VARCHAR2,
queue IN VARCHAR2,
queue_type IN NUMBER,
max_retries IN NUMBER,
retry_delay IN NUMBER,
queue_flags IN NUMBER,
retention IN NUMBER,
comment IN VARCHAR2);
dbms_aq_imp_internal.import_queue_seq(
name IN VARCHAR2,
qschema IN VARCHAR2,
shidcvl IN BINARY_INTEGER,
seqcvl IN BINARY_INTEGER,
subcvl IN BINARY_INTEGER,
rulecvl IN BINARY_INTEGER);
dbms_aq_imp_internal.import_queue_sharded_table(
schema IN VARCHAR2,
table_name IN VARCHAR2,
userdata_type IN NUMBER,
table_flags IN NUMBER,
sort_cols IN NUMBER,
primary_instance IN BINARY_INTEGER,
secondary_instance IN BINARY_INTEGER,
comment IN VARCHAR2,
timezone IN VARCHAR2,
version IN NUMBER);
dbms_aq_imp_internal.import_queue_table(
table_name IN VARCHAR2,
userdata_type IN NUMBER,
table_flags IN NUMBER,
sort_cols IN NUMBER,
primary_instance IN BINARY_INTEGER,
secondary_instance IN BINARY_INTEGER,
comment IN VARCHAR2,
db_version IN BINARY_INTEGER,
timezone IN VARCHAR2);