SELECT o$.obj#, o$.type#, o$.owner#, po$.parttype,
MOD(po$.spare2, 256), NVL(po$.flags, 0), po$.partcnt,
po$.partkeycols, MOD(po$.defpctfree, 100), po$.defpctused,
po$.definitrans, po$.defmaxtrans, po$.deftiniexts,
po$.defextsize, po$.defminexts, po$.defmaxexts, po$.defextpct,
po$.deflists, po$.defgroups, ts$.name, po$.deflogging,
DECODE(bitand(po$.spare1,3), 1, 'KEEP', 2, 'RECYCLE', NULL),
NVL(ts$.blocksize, 2048), /* non null for table/indexes */
(po$.spare2/4294967296), /* divide by ^x80000000 for byte 4 */
MOD(TRUNC(po$.spare2/65536), 65536), po$.defmaxsize
FROM sys.partobj$ po$, sys.obj$ o$, sys.ts$ ts$
WHERE po$.defts# = ts$.ts# (+) AND
po$.obj# = o$.obj#
SELECT O$.OBJ#
, O$.TYPE#
, O$.OWNER#
, PO$.PARTTYPE
,
MOD(PO$.SPARE2
, 256)
, NVL(PO$.FLAGS
, 0)
, PO$.PARTCNT
,
PO$.PARTKEYCOLS
, MOD(PO$.DEFPCTFREE
, 100)
, PO$.DEFPCTUSED
,
PO$.DEFINITRANS
, PO$.DEFMAXTRANS
, PO$.DEFTINIEXTS
,
PO$.DEFEXTSIZE
, PO$.DEFMINEXTS
, PO$.DEFMAXEXTS
, PO$.DEFEXTPCT
,
PO$.DEFLISTS
, PO$.DEFGROUPS
, TS$.NAME
, PO$.DEFLOGGING
,
DECODE(BITAND(PO$.SPARE1
, 3)
, 1
, 'KEEP'
, 2
, 'RECYCLE'
, NULL)
,
NVL(TS$.BLOCKSIZE
, 2048)
, /* NON NULL FOR TABLE/INDEXES */
(PO$.SPARE2/4294967296)
, /* DIVIDE BY ^X80000000 FOR BYTE 4 */
MOD(TRUNC(PO$.SPARE2/65536)
, 65536)
, PO$.DEFMAXSIZE
FROM SYS.PARTOBJ$ PO$
, SYS.OBJ$ O$
, SYS.TS$ TS$
WHERE PO$.DEFTS# = TS$.TS# (+) AND
PO$.OBJ# = O$.OBJ#
|
|
|