1
1
0
0
\{]`
0
0
0
0
0
0
0
0
0
DBMS_AQADM.CREATE_QUEUE_TABLE
AQ_QUEUE_TABLE
BEGIN DBMS_AQADM.CREATE_QUEUE_TABLE(
Queue_table => '
',
Queue_payload_type => '
VARIANT
RAW
',
storage_clause => '
PCTFREE
PCTUSED
INITRANS
MAXTRANS
TABLESPACE
'
,
Sort_list => '
PRIORITY
ENQ_TIME
PRIORITY,ENQ_TIME
ENQ_TIME,PRIORITY
'
,
Multiple_consumers => TRUE
,
Message_grouping => 1
,
Compatible => '8.1.3'
Compatible => '8.0.3'
,
comment => '
'
,
primary_instance =>
,
secondary_instance =>
)
;
END
;
DBMS_AQ_IMP_INTERNAL
AQ_QUEUE_TABLE
BEGIN
SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE_TABLE('
',
,
+4
+112
,
,
,
,'
')
;
SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_SUBSCRIBER_TABLE('AQ$_
_S')
;
SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_TIMEMGR_TABLE('AQ$_
_T')
;
SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_HISTORY_TABLE('AQ$_
_H')
;
SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_SIGNATURE_TABLE('AQ$_
_NR')
;
SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_INDEX_TABLE('AQ$_
_I')
;
END
;