IX.AQ$ STREAMS QUEUE TABLE H (table)

From dbscript Online Help
Revision as of 08:27, 11 February 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table IX.AQ$_STREAMS_QUEUE_TABLE_H


Columns

Column Data Type Nullable Default Description
MSGID RAW(16) not null
SUBSCRIBER# NUMBER not null
NAME VARCHAR2(30) not null
ADDRESS# NUMBER not null
DEQUEUE_TIME TIMESTAMP(6) null
TRANSACTION_ID VARCHAR2(30) null
DEQUEUE_USER VARCHAR2(30) null
PROPAGATED_MSGID RAW(16) null
RETRY_COUNT NUMBER null
HINT ROWID null
SPARE RAW(16) null

Primary Key

Primary Key Columns
SYS_IOT_TOP_49920 MSGID, SUBSCRIBER#, NAME, ADDRESS#