VIEW: SYS.KU$_PARTLOB_VIEW

Source

View Text - Preformatted

select l.tabobj#, l.intcol#,
        (select value(o) from ku$_schemaobj_view o
         where o.obj_num = l.lobj#),
        (select ts.name from ts$ ts where l.defts# = ts.ts#),
        NVL(
          (select ts.blocksize from ts$ ts where l.defts# = ts.ts#),
          NVL(         /* should be avail. thru lobcompart, lobfrag if null */
            (select ts.blocksize
             from   ts$ ts, lobfrag$ lf
             where  l.lobj# = lf.parentobj# and
                    lf.ts# = ts.ts# and rownum < 2),
            (select ts.blocksize
             from   ts$ ts, lobcomppart$ lcp, lobfrag$ lf
             where  l.lobj# = lcp.lobj# and
                    lcp.partobj# = lf.parentobj# and
                    lf.ts# = ts.ts# and rownum < 2))),
        l.defchunk, l.defpctver$, l.defflags, l.defpro,
        l.definiexts, l.defextsize, l.defminexts, l.defmaxexts,
        l.defextpct, l.deflists, l.defgroups, l.defbufpool,
        l.spare1, l.spare2, l.spare3,
        l.defmaxsize, l.defretention, l.defmintime
  from partlob$ l

View Text - HTML Formatted

SELECT L.TABOBJ#
, L.INTCOL#
, (SELECT VALUE(O)
FROM KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM = L.LOBJ#)
, (SELECT TS.NAME
FROM TS$ TS
WHERE L.DEFTS# = TS.TS#)
, NVL( (SELECT TS.BLOCKSIZE
FROM TS$ TS
WHERE L.DEFTS# = TS.TS#)
, NVL( /* SHOULD BE AVAIL. THRU LOBCOMPART
, LOBFRAG IF NULL */ (SELECT TS.BLOCKSIZE
FROM TS$ TS
, LOBFRAG$ LF
WHERE L.LOBJ# = LF.PARENTOBJ# AND LF.TS# = TS.TS#
AND ROWNUM < 2)
, (SELECT TS.BLOCKSIZE
FROM TS$ TS
, LOBCOMPPART$ LCP
, LOBFRAG$ LF
WHERE L.LOBJ# = LCP.LOBJ# AND LCP.PARTOBJ# = LF.PARENTOBJ# AND LF.TS# = TS.TS#
AND ROWNUM < 2)))
, L.DEFCHUNK
, L.DEFPCTVER$
, L.DEFFLAGS
, L.DEFPRO
, L.DEFINIEXTS
, L.DEFEXTSIZE
, L.DEFMINEXTS
, L.DEFMAXEXTS
, L.DEFEXTPCT
, L.DEFLISTS
, L.DEFGROUPS
, L.DEFBUFPOOL
, L.SPARE1
, L.SPARE2
, L.SPARE3
, L.DEFMAXSIZE
, L.DEFRETENTION
, L.DEFMINTIME
FROM PARTLOB$ L