Difference between revisions of "IX.AQ$ STREAMS QUEUE TABLE I (table)"

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
−
| '''table
+
| '''Table
 
| IX.AQ$_STREAMS_QUEUE_TABLE_I
 
| IX.AQ$_STREAMS_QUEUE_TABLE_I
−
|-
+
|}
 +
 
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 
 +
|- valign="top"
 +
| SUBSCRIBER#
 +
| NUMBER
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| NAME
 +
| VARCHAR2(30)
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| QUEUE#
 +
| NUMBER
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| MSG_ENQ_TID
 +
| VARCHAR2(30)
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| SENDER#
 +
| NUMBER
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| TXN_STEP#
 +
| NUMBER
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| MSG_ENQ_TIME
 +
| TIMESTAMP(6)
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| MSG_STEP_NO
 +
| NUMBER
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| MSG_CHAIN_NO
 +
| NUMBER
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| MSG_LOCAL_ORDER_NO
 +
| NUMBER
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| MSGID
 +
| RAW(16)
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| HINT
 +
| ROWID
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| SPARE
 +
| RAW(16)
 +
| null
 +
|
 +
|
 +
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| 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
 
|}
 
|}

Latest revision as of 07:14, 24 June 2010

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
Retrieved from "http://dbshelp.devio.at/index.php?title=IX.AQ$_STREAMS_QUEUE_TABLE_I_(table)&oldid=2725"