Name Value
CREATED 14.03.13
LAST_DDL_TIME 14.03.13
OWNER XPPADMDEV
INDEX_NAME SYS_IOT_TOP_87240
INDEX_TYPE IOT - TOP
TABLE_OWNER XPPADMDEV
TABLE_NAME AQ$_QTAB_TEST02_I
TABLE_TYPE TABLE
UNIQUENESS UNIQUE
COMPRESSION DISABLED
PREFIX_LENGTH null
TABLESPACE_NAME USERS
INI_TRANS 2
MAX_TRANS 255
INITIAL_EXTENT 65536
NEXT_EXTENT 1048576
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE null
PCT_THRESHOLD 50
INCLUDE_COLUMN 0
FREELISTS null
FREELIST_GROUPS null
PCT_FREE 10
LOGGING YES
BLEVEL null
LEAF_BLOCKS null
DISTINCT_KEYS null
AVG_LEAF_BLOCKS_PER_KEY null
AVG_DATA_BLOCKS_PER_KEY null
CLUSTERING_FACTOR null
STATUS VALID
NUM_ROWS null
SAMPLE_SIZE null
LAST_ANALYZED null
DEGREE 1
INSTANCES 1
PARTITIONED NO
TEMPORARY N
GENERATED Y
SECONDARY N
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
USER_STATS NO
DURATION null
PCT_DIRECT_ACCESS 0
ITYP_OWNER null
ITYP_NAME null
PARAMETERS null
GLOBAL_STATS NO
DOMIDX_STATUS null
DOMIDX_OPSTATUS null
FUNCIDX_STATUS null
JOIN_INDEX NO
IOT_REDUNDANT_PKEY_ELIM NO
DROPPED NO
VISIBILITY VISIBLE
DOMIDX_MANAGEMENT null
SEGMENT_CREATED YES