Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

Navigation¶

Main Page

Create Account

Search the wiki
»

PoweredBy

Discuss (0) View Page Code History

IX AQ$_STREAMS_QUEUE_TABLE_I (table)

Print

RSS

Modified on 2011/08/27 12:09 by wikibot Categorized as Uncategorized

» IX AQ$_STREAMS_QUEUE_TABLE_I (table)

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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.