From dbscript Online Help
wikibot
| Table
|
IX.AQ$_STREAMS_QUEUE_TABLE_I
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| SUBSCRIBER#
|
NUMBER
|
not null
|
|
|
| NAME
|
VARCHAR2(30)
|
not null
|
|
|
| QUEUE#
|
NUMBER
|
not null
|
|
|
| MSG_ENQ_TID
|
VARCHAR2(30)
|
not null
|
|
|
| SENDER#
|
NUMBER
|
not null
|
|
|
| TXN_STEP#
|
NUMBER
|
not null
|
|
|
| MSG_ENQ_TIME
|
TIMESTAMP(6)
|
not null
|
|
|
| MSG_STEP_NO
|
NUMBER
|
not null
|
|
|
| MSG_CHAIN_NO
|
NUMBER
|
not null
|
|
|
| MSG_LOCAL_ORDER_NO
|
NUMBER
|
not null
|
|
|
| MSGID
|
RAW(16)
|
not null
|
|
|
| HINT
|
ROWID
|
null
|
|
|
| SPARE
|
RAW(16)
|
null
|
|
|
Primary Key
| Primary Key
|
Columns
|
| SYS_IOT_TOP_49925
|
SUBSCRIBER#, NAME, QUEUE#, MSG_ENQ_TID, SENDER#, TXN_STEP#, MSG_ENQ_TIME, MSG_STEP_NO, MSG_CHAIN_NO, MSG_LOCAL_ORDER_NO, MSGID
|
