select obj#, dataobj#, pobj#,
row_number() over (partition by pobj# order by subpart#),
flags, ts#, file#, block#, pctfree$,
initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt,
distkey, lblkkey, dblkkey, clufac, spare1, spare2, spare3,
hiboundlen, hiboundval, subpart#
from indsubpart$
where bitand(flags, 8388608) = 0 /* filter out hidden partitions */
SELECT OBJ#
, DATAOBJ#
, POBJ#
,
ROW_NUMBER() OVER (PARTITION BY POBJ# ORDER BY SUBPART#)
,
FLAGS
, TS#
, FILE#
, BLOCK#
, PCTFREE$
,
INITRANS
, MAXTRANS
, ANALYZETIME
, SAMPLESIZE
, ROWCNT
, BLEVEL
, LEAFCNT
,
DISTKEY
, LBLKKEY
, DBLKKEY
, CLUFAC
, SPARE1
, SPARE2
, SPARE3
,
HIBOUNDLEN
, HIBOUNDVAL
, SUBPART#
FROM INDSUBPART$
WHERE BITAND(FLAGS
, 8388608) = 0 /* FILTER OUT HIDDEN PARTITIONS */
|
|
|