VIEW: SYS.KU$_LOBCOMPPART_VIEW

Source

View Text - Preformatted

select lc.partobj#, lc.tabpartobj#,
        dbms_metadata.get_partn(8,lc.lobj#, lc.part#),
        (select l.intcol# from lob$ l where l.lobj#=lc.lobj#),
        (select value(o) from ku$_schemaobj_view o
         where o.obj_num = lc.partobj#),
        (select ts.name from ts$ ts where lc.defts# = ts.ts#),
        (select ts.blocksize from ts$ ts where lc.defts# = ts.ts#),
        lc.defchunk, lc.defpctver$, lc.defflags, lc.defpro,
        lc.definiexts, lc.defextsize, lc.defminexts, lc.defmaxexts,
        lc.defextpct, lc.deflists, lc.defgroups, lc.defbufpool,
        lc.spare1, lc.spare2, lc.spare3,
        lc.defmaxsize, lc.defretention, lc.defmintime
  from lobcomppart$ lc

View Text - HTML Formatted

SELECT LC.PARTOBJ#
, LC.TABPARTOBJ#
, DBMS_METADATA.GET_PARTN(8
, LC.LOBJ#
, LC.PART#)
, (SELECT L.INTCOL#
FROM LOB$ L
WHERE L.LOBJ#=LC.LOBJ#)
, (SELECT VALUE(O)
FROM KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM = LC.PARTOBJ#)
, (SELECT TS.NAME
FROM TS$ TS
WHERE LC.DEFTS# = TS.TS#)
, (SELECT TS.BLOCKSIZE
FROM TS$ TS
WHERE LC.DEFTS# = TS.TS#)
, LC.DEFCHUNK
, LC.DEFPCTVER$
, LC.DEFFLAGS
, LC.DEFPRO
, LC.DEFINIEXTS
, LC.DEFEXTSIZE
, LC.DEFMINEXTS
, LC.DEFMAXEXTS
, LC.DEFEXTPCT
, LC.DEFLISTS
, LC.DEFGROUPS
, LC.DEFBUFPOOL
, LC.SPARE1
, LC.SPARE2
, LC.SPARE3
, LC.DEFMAXSIZE
, LC.DEFRETENTION
, LC.DEFMINTIME
FROM LOBCOMPPART$ LC