IX.STREAMS QUEUE TABLE (table)
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
|
