 |
|
DBMS_AQ_SYS_IMP_INTERNAL package tips
Oracle Tips by Burleson Consulting |
DBMS_AQ_SYS_IMP_INTERNAL
<< Return to the index
Oracle 11g provides the following information about the DBMS_AQ_SYS_IMP_INTERNAL package:
Description of the DBMS_AQ_SYS_IMP_INTERNAL package:
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.BUMP_TID_SEQUENCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MINVAL NUMBER IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.CLEANUP_SCHEMA_IMPORT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.IMPORT_CMT_TIME_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
IOT VARCHAR2 IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.IMPORT_HISTORY_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
IOT VARCHAR2 IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.IMPORT_INDEX_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
IOT VARCHAR2 IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.IMPORT_QUEUE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OID RAW IN
SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
QUEUE VARCHAR2 IN
QUEUE_TYPE NUMBER IN
MAX_RETRIES NUMBER IN
RETRY_DELAY NUMBER IN
QUEUE_FLAGS NUMBER IN
RETENTION NUMBER IN
COMMENT VARCHAR2 IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.IMPORT_QUEUE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
TABLE_NAME VARCHAR2 IN
USERDATA_TYPE NUMBER IN
TABLE_FLAGS NUMBER IN
SORT_COLS NUMBER IN
PRIMARY_INSTANCE BINARY_INTEGER IN
SECONDARY_INSTANCE BINARY_INTEGER IN
COMMENT VARCHAR2 IN
DB_VERSION BINARY_INTEGER IN DEFAULT
TIMEZONE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.IMPORT_SIGNATURE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
IOT VARCHAR2 IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.IMPORT_SUBSCRIBER_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
SUBSCRIBER_TABLE VARCHAR2 IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.IMPORT_TIMEMGR_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
IOT VARCHAR2 IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.POST_TTS_REBUILD_IDX
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
PROCEDURE DBMS_AQ_SYS_IMP_INTERNAL.POST_TTS_WORK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
QUEUE_TABLE VARCHAR2 IN
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
