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 |
