Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

QS


Description  Columns  Primary key  Check constraints  Foreign keys  Unique keys  Indexes  Options  Referenced by  Triggers  

AQ$_QS_ORDERS_PR_MQTAB_I

Columns

Column Datatype Nullable Default value Comment
SUBSCRIBER# NUMBER(,) N    
NAME VARCHAR2(30) N    
QUEUE# NUMBER(,) N    
MSG_PRIORITY NUMBER(,) N    
MSG_ENQ_TIME DATE N    
MSG_STEP_NO NUMBER(,) N    
MSG_CHAIN_NO NUMBER(,) N    
MSG_LOCAL_ORDER_NO NUMBER(,) N    
MSGID RAW(16) N    
HINT ROWID(10) Y    
SPARE RAW(16) Y    

Primary key

Primary key Columns
SYS_IOT_TOP_29884 SUBSCRIBER#, NAME, QUEUE#, MSG_PRIORITY, MSG_ENQ_TIME, MSG_STEP_NO, MSG_CHAIN_NO, MSG_LOCAL_ORDER_NO, MSGID

Indexes

Index Type Uniqueness Columns
SYS_IOT_TOP_29884 IOT - TOP UNIQUE SUBSCRIBER#, NAME, QUEUE#, MSG_PRIORITY, MSG_ENQ_TIME, MSG_STEP_NO, MSG_CHAIN_NO, MSG_LOCAL_ORDER_NO, MSGID

Options

Option Setting
Clustered N
Generated by Oracle N
Index Organized Y
Logging Y
Partitioned N
Temporary N
Nested N


Generated by
OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005