Welcome Guest, you are in: <root> • Login

Page History: IX AQ$_STREAMS_QUEUE_TABLE_I (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:18

wikibot ¶

Table

IX.AQ$_STREAMS_QUEUE_TABLE_I

Columns ¶

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 ¶

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