VIEW: SYS.EXPCOMPRESSEDPART

Source

View Text - Preformatted

SELECT s.spare1, t.obj#
        FROM   sys.tabpart$ t, sys.seg$ s
        WHERE  t.ts#    = s.ts#
        AND    t.file#  = s.file#
        AND    t.block# = s.block#
        AND    s.type#  = 5
        AND    (bitand(s.spare1,4096) = 4096 OR bitand(s.spare1,2048) = 2048)

View Text - HTML Formatted

SELECT S.SPARE1
, T.OBJ#
FROM SYS.TABPART$ T
, SYS.SEG$ S
WHERE T.TS# = S.TS#
AND T.FILE# = S.FILE#
AND T.BLOCK# = S.BLOCK#
AND S.TYPE# = 5
AND (BITAND(S.SPARE1
, 4096) = 4096 OR BITAND(S.SPARE1
, 2048) = 2048)