IX AQ$_STREAMS_QUEUE_TABLE_I (table)

wikibot

TableIX.AQ$_STREAMS_QUEUE_TABLE_I

Columns

ColumnData TypeNullableDefaultDescription
SUBSCRIBER#NUMBERnot null  
NAMEVARCHAR2(30)not null  
QUEUE#NUMBERnot null  
MSG_ENQ_TIDVARCHAR2(30)not null  
SENDER#NUMBERnot null  
TXN_STEP#NUMBERnot null  
MSG_ENQ_TIMETIMESTAMP(6)not null  
MSG_STEP_NONUMBERnot null  
MSG_CHAIN_NONUMBERnot null  
MSG_LOCAL_ORDER_NONUMBERnot null  
MSGIDRAW(16)not null  
HINTROWIDnull  
SPARERAW(16)null  

Primary Key

Primary KeyColumns
SYS_IOT_TOP_49925SUBSCRIBER#, NAME, QUEUE#, MSG_ENQ_TID, SENDER#, TXN_STEP#, MSG_ENQ_TIME, MSG_STEP_NO, MSG_CHAIN_NO, MSG_LOCAL_ORDER_NO, MSGID