USER_INDEXES

Name	Null?	Type	Value
INDEX_NAME	NOT NULL	VARCHAR2(30)
INDEX_TYPE		VARCHAR2(27)	NULL
TABLE_OWNER	NOT NULL	VARCHAR2(30)
TABLE_NAME	NOT NULL	VARCHAR2(30)
TABLE_TYPE		VARCHAR2(11)	"TABLE"
UNIQUENESS		VARCHAR2(9)	"UNIQUE" or "NONUNIQUE"
COMPRESSION		VARCHAR2(8)	NULL
PREFIX_LENGTH		NUMBER	0
TABLESPACE_NAME		VARCHAR2(30)	NULL
INI_TRANS		NUMBER	0
MAX_TRANS		NUMBER	0
INITIAL_EXTENT		NUMBER	0
NEXT_EXTENT		NUMBER	0
MIN_EXTENTS		NUMBER	0
MAX_EXTENTS		NUMBER	0
PCT_INCREASE		NUMBER	0
PCT_THRESHOLD		NUMBER	0
INCLUDE_COLUMNS		NUMBER	0
FREELISTS		NUMBER	0
FREELIST_GROUPS		NUMBER	0
PCT_FREE		NUMBER	0
LOGGING		VARCHAR2(3)	NULL
BLEVEL		NUMBER	0
LEAF_BLOCKS		NUMBER	0
DISTINCT_KEYS		NUMBER
AVG_LEAF_BLOCKS_PER_KEY		NUMBER	0
AVG_DATA_BLOCKS_PER_KEY		NUMBER	0
CLUSTERING_FACTOR		NUMBER	0
STATUS		VARCHAR2(8)	NULL
NUM_ROWS		NUMBER	0
SAMPLE_SIZE		NUMBER	0
LAST_ANALYZED		DATE	NULL
DEGREE		VARCHAR2(40)	NULL
INSTANCES		VARCHAR2(40)	NULL
PARTITIONED		VARCHAR2(3)	NULL
TEMPORARY		VARCHAR2(1)	NULL
GENERATED		VARCHAR2(1)	NULL
SECONDARY		VARCHAR2(1)	NULL
BUFFER_POOL		VARCHAR2(7)	NULL
USER_STATS		VARCHAR2(3)	NULL
DURATION		VARHCAR2(15)	NULL
PCT_DIRECT_ACCESS		NUMBER	0
ITYP_OWNER		VARCHAR2(30)	NULL
ITYP_NAME		VARCHAR2(30)	NULL
PARAMETERS		VARCHAR2(1000)	NULL
GLOBAL_STATS		VARCHAR2(3)	NULL
DOMIDX_STATUS		VARCHAR2(12)	NULL
DOMIDX_OPSTATUS		VARCHAR2(6)	NULL
FUNCIDX_STATUS		VARCHAR2(8)	NULL