VIEW: SYS.KU$_PIOT_PART_VIEW

Source

View Text - Preformatted

select ip.obj#,
         (select value(so) from ku$_schemaobj_view so
          where so.obj_num = ip.obj#),
         ts.name, ts.blocksize,
         (select value(s) from ku$_storage_view s
          where ip.file#  = s.file_num
          and   ip.block# = s.block_num
          and   ip.ts#    = s.ts_num),
         (select value(s) from ku$_deferred_stg_view s
          where s.obj_num = ip.obj#),
         ip.dataobj#, ip.bo#,
         dbms_metadata.get_partn(4,ip.bo#,ip.part#),
         ip.hiboundlen,
         sys.dbms_metadata_util.long2varchar(ip.hiboundlen,
                                    'SYS.INDPART$',
                                    'HIBOUNDVAL',
                                     ip.rowid),
         cast(multiset(select lf.* from ind$ i, ku$_piotlobfrag_view lf
                        where lf.part_num=
                                dbms_metadata.get_partn(4,ip.bo#,ip.part#)
                          and ip.bo#=i.obj# and i.bo#=lf.base_obj_num
                        order by lf.intcol_num
                      ) as ku$_lobfrag_list_t
             ),
         ip.flags, ip.pctfree$, ip.pctthres$,
         ip.initrans, ip.maxtrans,
         to_char(ip.analyzetime,'YYYY/MM/DD HH24:MI:SS'), ip.samplesize,
         ip.rowcnt, ip.blevel, ip.leafcnt, ip.distkey, ip.lblkkey,
         ip.dblkkey, ip.clufac, ip.spare1, ip.spare2, ip.spare3,
         ip.inclcol
  from  indpart$ ip, ts$ ts
  where ip.ts# = ts.ts#

View Text - HTML Formatted

SELECT IP.OBJ#
, (SELECT VALUE(SO)
FROM KU$_SCHEMAOBJ_VIEW SO
WHERE SO.OBJ_NUM = IP.OBJ#)
, TS.NAME
, TS.BLOCKSIZE
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE IP.FILE# = S.FILE_NUM
AND IP.BLOCK# = S.BLOCK_NUM
AND IP.TS# = S.TS_NUM)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = IP.OBJ#)
, IP.DATAOBJ#
, IP.BO#
, DBMS_METADATA.GET_PARTN(4
, IP.BO#
, IP.PART#)
, IP.HIBOUNDLEN
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(IP.HIBOUNDLEN
, 'SYS.INDPART$'
, 'HIBOUNDVAL'
, IP.ROWID)
, CAST(MULTISET(SELECT LF.*
FROM IND$ I
, KU$_PIOTLOBFRAG_VIEW LF
WHERE LF.PART_NUM= DBMS_METADATA.GET_PARTN(4
, IP.BO#
, IP.PART#)
AND IP.BO#=I.OBJ#
AND I.BO#=LF.BASE_OBJ_NUM ORDER BY LF.INTCOL_NUM ) AS KU$_LOBFRAG_LIST_T )
, IP.FLAGS
, IP.PCTFREE$
, IP.PCTTHRES$
, IP.INITRANS
, IP.MAXTRANS
, TO_CHAR(IP.ANALYZETIME
, 'YYYY/MM/DD HH24:MI:SS')
, IP.SAMPLESIZE
, IP.ROWCNT
, IP.BLEVEL
, IP.LEAFCNT
, IP.DISTKEY
, IP.LBLKKEY
, IP.DBLKKEY
, IP.CLUFAC
, IP.SPARE1
, IP.SPARE2
, IP.SPARE3
, IP.INCLCOL
FROM INDPART$ IP
, TS$ TS
WHERE IP.TS# = TS.TS#