select partobj#, lobj#, tabpartobj#, indpartobj#,
row_number() over (partition by lobj# order by part#),
defts#, defchunk, defpctver$, defflags, defpro, definiexts,
defextsize, defminexts, defmaxexts, defmaxsize, defretention,
defmintime, defextpct, deflists,
defgroups, defbufpool, spare1, spare2, spare3
from lobcomppart$
where bitand(defflags, 67108864) = 0 /* filter out hidden fragments */
SELECT PARTOBJ#
, LOBJ#
, TABPARTOBJ#
, INDPARTOBJ#
,
ROW_NUMBER() OVER (PARTITION BY LOBJ# ORDER BY PART#)
,
DEFTS#
, DEFCHUNK
, DEFPCTVER$
, DEFFLAGS
, DEFPRO
, DEFINIEXTS
,
DEFEXTSIZE
, DEFMINEXTS
, DEFMAXEXTS
, DEFMAXSIZE
, DEFRETENTION
,
DEFMINTIME
, DEFEXTPCT
, DEFLISTS
,
DEFGROUPS
, DEFBUFPOOL
, SPARE1
, SPARE2
, SPARE3
FROM LOBCOMPPART$
WHERE BITAND(DEFFLAGS
, 67108864) = 0 /* FILTER OUT HIDDEN FRAGMENTS */
|
|
|