VIEW: SYS.KU$_TTS_PARTLOBVIEW

Source

View Text - Preformatted

SELECT tp.bo#, value(po), ts.name, ts.ts#
    FROM  sys.ku$_schemaobj_view po, sys.tabpart$ tp,
          sys.lobfrag$ lf, sys.ts$ ts
    WHERE  po.obj_num = tp.obj# and
           lf.tabfragobj# = tp.obj# and
           lf.ts# = ts.ts#

View Text - HTML Formatted

SELECT TP.BO#
, VALUE(PO)
, TS.NAME
, TS.TS#
FROM SYS.KU$_SCHEMAOBJ_VIEW PO
, SYS.TABPART$ TP
, SYS.LOBFRAG$ LF
, SYS.TS$ TS
WHERE PO.OBJ_NUM = TP.OBJ# AND LF.TABFRAGOBJ# = TP.OBJ# AND LF.TS# = TS.TS#