CREATE OR REPLACE VIEW DBA_IND_PARTITIONS ( INDEX_OWNER, 
INDEX_NAME, PARTITION_NAME, HIGH_VALUE, HIGH_VALUE_LENGTH, 
PARTITION_POSITION, STATUS, TABLESPACE_NAME, PCT_FREE, 
INI_TRANS, MAX_TRANS, INITIAL_EXTENT, NEXT_EXTENT, 
MIN_EXTENT, MAX_EXTENT, PCT_INCREASE, FREELISTS, 
FREELIST_GROUPS, LOGGING, BLEVEL, LEAF_BLOCKS, 
DISTINCT_KEYS, AVG_LEAF_BLOCKS_PER_KEY, AVG_DATA_BLOCKS_PER_KEY, CLUSTERING_FACTOR, 
NUM_ROWS, SAMPLE_SIZE, LAST_ANALYZED, BUFFER_POOL
 ) AS select u.name, o.name, o.subname, ip.hiboundval, ip.hiboundlen, ip.part#, 
        decode(bitand(ip.flags, 1), 1, 'UNUSABLE', 'USABLE'), ts.name,
       ip.pctfree$,ip.initrans, ip.maxtrans, s.iniexts * ts.blocksize, 
       s.extsize * ts.blocksize, s.minexts, s.maxexts, s.extpct, 
       decode(s.lists, 0, 1, s.lists),
       decode(s.groups, 0, 1, s.groups),
       decode(mod(trunc(ip.flags / 4), 2), 0, 'YES', 'NO'), 
       ip.blevel, ip.leafcnt, ip.distkey, ip.lblkkey, ip.dblkkey, 
       ip.clufac, ip.rowcnt, ip.samplesize, ip.analyzetime,
       decode(s.cachehint, 0, 'DEFAULT', 1, 'KEEP', 2, 'RECYCLE', NULL)
from obj$ o, indpart$ ip, ts$ ts, sys.seg$ s, user$ u
where o.obj# = ip.obj# and ts.ts# = ip.ts# and ip.file#=s.file# and
      ip.block#=s.block# and ip.ts#=s.ts# and o.owner# = u.user#