VIEW: SYS.KU$_TAB_SUBPART_VIEW

Source

View Text - Preformatted

select tsp.obj#, value(o),
         ts.name, ts.blocksize,
         (select value(s) from ku$_storage_view s
          where tsp.file#  = s.file_num
          and   tsp.block# = s.block_num
          and   tsp.ts#    = s.ts_num),
         (select value(s) from ku$_deferred_stg_view s
          where s.obj_num = tsp.obj#),
         tsp.dataobj#,
         tsp.pobj#,
         dbms_metadata.get_partn(3,tsp.pobj#,tsp.subpart#),
         cast(multiset(select * from ku$_sublobfrag_view lf
                        where lf.part_obj_num=tsp.obj#
                        order by lf.intcol_num
                      ) as ku$_lobfrag_list_t
             ),
         cast( multiset(select * from ku$_ilm_policy_view p
                        where p.obj_num = tsp.obj#
                        order by p.policy_num
                        ) as ku$_ilm_policy_list_t
              ),
         tsp.flags, tsp.pctfree$, tsp.pctused$,
         tsp.initrans, tsp.maxtrans,
         to_char(tsp.analyzetime,'YYYY/MM/DD HH24:MI:SS'), tsp.samplesize,
         tsp.rowcnt, tsp.blkcnt, tsp.empcnt, tsp.avgspc, tsp.chncnt,
         tsp.avgrln, tsp.spare1, tsp.spare2, tsp.spare3, tsp.hiboundlen,
         sys.dbms_metadata_util.long2varchar(tsp.hiboundlen,
                                    'SYS.TABSUBPART$',
                                    'HIBOUNDVAL',
                                     tsp.rowid),
         tsp.bhiboundval
  from ku$_schemaobj_view o, tabsubpart$ tsp, ts$ ts
  where tsp.obj# = o.obj_num
        AND tsp.ts# = ts.ts#

View Text - HTML Formatted

SELECT TSP.OBJ#
, VALUE(O)
, TS.NAME
, TS.BLOCKSIZE
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE TSP.FILE# = S.FILE_NUM
AND TSP.BLOCK# = S.BLOCK_NUM
AND TSP.TS# = S.TS_NUM)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = TSP.OBJ#)
, TSP.DATAOBJ#
, TSP.POBJ#
, DBMS_METADATA.GET_PARTN(3
, TSP.POBJ#
, TSP.SUBPART#)
, CAST(MULTISET(SELECT *
FROM KU$_SUBLOBFRAG_VIEW LF
WHERE LF.PART_OBJ_NUM=TSP.OBJ# ORDER BY LF.INTCOL_NUM ) AS KU$_LOBFRAG_LIST_T )
, CAST( MULTISET(SELECT *
FROM KU$_ILM_POLICY_VIEW P
WHERE P.OBJ_NUM = TSP.OBJ# ORDER BY P.POLICY_NUM ) AS KU$_ILM_POLICY_LIST_T )
, TSP.FLAGS
, TSP.PCTFREE$
, TSP.PCTUSED$
, TSP.INITRANS
, TSP.MAXTRANS
, TO_CHAR(TSP.ANALYZETIME
, 'YYYY/MM/DD HH24:MI:SS')
, TSP.SAMPLESIZE
, TSP.ROWCNT
, TSP.BLKCNT
, TSP.EMPCNT
, TSP.AVGSPC
, TSP.CHNCNT
, TSP.AVGRLN
, TSP.SPARE1
, TSP.SPARE2
, TSP.SPARE3
, TSP.HIBOUNDLEN
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(TSP.HIBOUNDLEN
, 'SYS.TABSUBPART$'
, 'HIBOUNDVAL'
, TSP.ROWID)
, TSP.BHIBOUNDVAL
FROM KU$_SCHEMAOBJ_VIEW O
, TABSUBPART$ TSP
, TS$ TS
WHERE TSP.OBJ# = O.OBJ_NUM
AND TSP.TS# = TS.TS#