VIEW: SYS.KU$_OV_TABPART_VIEW

Source

View Text - Preformatted

select t.obj#, t.dataobj#, t.bo#,
         dbms_metadata.get_partn(1,t.bo#,t.part#),
         (select value(s) from ku$_storage_view s
          where t.file# = s.file_num
          and t.block#  = s.block_num
          and t.ts#     = s.ts_num),
         (select value(s) from ku$_deferred_stg_view s
          where s.obj_num = t.obj#),
         ts.name, ts.blocksize,
         t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.flags
  from  tabpart$ t, ts$ ts
  where t.ts# = ts.ts#

View Text - HTML Formatted

SELECT T.OBJ#
, T.DATAOBJ#
, T.BO#
, DBMS_METADATA.GET_PARTN(1
, T.BO#
, T.PART#)
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE T.FILE# = S.FILE_NUM
AND T.BLOCK# = S.BLOCK_NUM
AND T.TS# = S.TS_NUM)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = T.OBJ#)
, TS.NAME
, TS.BLOCKSIZE
, T.PCTFREE$
, T.PCTUSED$
, T.INITRANS
, T.MAXTRANS
, T.FLAGS
FROM TABPART$ T
, TS$ TS
WHERE T.TS# = TS.TS#