From dbscript Online Help
wikibot
| Table
|
IX.STREAMS_QUEUE_TABLE
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| Q_NAME
|
VARCHAR2(30)
|
null
|
|
|
| MSGID
|
RAW(16)
|
not null
|
|
|
| CORRID
|
VARCHAR2(128)
|
null
|
|
|
| PRIORITY
|
NUMBER
|
null
|
|
|
| STATE
|
NUMBER
|
null
|
|
|
| DELAY
|
TIMESTAMP(6)
|
null
|
|
|
| EXPIRATION
|
NUMBER
|
null
|
|
|
| TIME_MANAGER_INFO
|
TIMESTAMP(6)
|
null
|
|
|
| LOCAL_ORDER_NO
|
NUMBER
|
null
|
|
|
| CHAIN_NO
|
NUMBER
|
null
|
|
|
| CSCN
|
NUMBER
|
null
|
|
|
| DSCN
|
NUMBER
|
null
|
|
|
| ENQ_TIME
|
TIMESTAMP(6)
|
null
|
|
|
| ENQ_UID
|
VARCHAR2(30)
|
null
|
|
|
| ENQ_TID
|
VARCHAR2(30)
|
null
|
|
|
| DEQ_TIME
|
TIMESTAMP(6)
|
null
|
|
|
| DEQ_UID
|
VARCHAR2(30)
|
null
|
|
|
| DEQ_TID
|
VARCHAR2(30)
|
null
|
|
|
| RETRY_COUNT
|
NUMBER
|
null
|
|
|
| EXCEPTION_QSCHEMA
|
VARCHAR2(30)
|
null
|
|
|
| EXCEPTION_QUEUE
|
VARCHAR2(30)
|
null
|
|
|
| STEP_NO
|
NUMBER
|
null
|
|
|
| RECIPIENT_KEY
|
NUMBER
|
null
|
|
|
| DEQUEUE_MSGID
|
RAW(16)
|
null
|
|
|
| SENDER_NAME
|
VARCHAR2(30)
|
null
|
|
|
| SENDER_ADDRESS
|
VARCHAR2(1024)
|
null
|
|
|
| SENDER_PROTOCOL
|
NUMBER
|
null
|
|
|
| USER_DATA
|
SYS.ANYDATA
|
null
|
|
|
| USER_PROP
|
SYS.ANYDATA
|
null
|
|
|
Primary Key
| Primary Key
|
Columns
|
| SYS_C005067
|
MSGID
|
