IX.AQ$ STREAMS QUEUE TABLE I (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table IX.AQ$_STREAMS_QUEUE_TABLE_I

Columns[edit]

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[edit]

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