VIEW: SYS.KU$_IOT_PARTOBJ_VIEW

Source

View Text - Preformatted

select t.obj#,
         (select value (tpo) from ku$_partobj_view tpo
          where t.obj# = tpo.obj_num),
         cast(multiset(select * from ku$_tab_part_col_view pc
                       where pc.obj_num = t.obj#
                        order by pc.pos_num
                      ) as ku$_part_col_list_t
             ),
         cast(multiset(select * from ku$_tab_subpart_col_view sc
                       where sc.obj_num = t.obj#
                        order by sc.pos_num
                      ) as ku$_part_col_list_t
             ),
         (select value (ipo) from ku$_partobj_view ipo
          where i.obj# = ipo.obj_num),
         (select value (ovpo) from ku$_partobj_view ovpo
          where t.bobj# = ovpo.obj_num),
         cast(multiset(select * from ku$_piot_part_view ip
                       where ip.base_obj_num = i.obj#
                        order by ip.part_num
                      ) as ku$_piot_part_list_t
             ),
         cast(multiset(select * from ku$_ov_tabpart_view ovp
                       where ovp.bobj_num = t.bobj#
                        order by ovp.part_num
                      ) as ku$_ov_tabpart_list_t
             )
  from tab$ t, ind$ i
  where i.bo#=t.obj#
    and i.type#=4                       -- iot index
    and bitand(t.property,32)=32        -- partitioned table

View Text - HTML Formatted

SELECT T.OBJ#
, (SELECT VALUE (TPO)
FROM KU$_PARTOBJ_VIEW TPO
WHERE T.OBJ# = TPO.OBJ_NUM)
, CAST(MULTISET(SELECT *
FROM KU$_TAB_PART_COL_VIEW PC
WHERE PC.OBJ_NUM = T.OBJ# ORDER BY PC.POS_NUM ) AS KU$_PART_COL_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_TAB_SUBPART_COL_VIEW SC
WHERE SC.OBJ_NUM = T.OBJ# ORDER BY SC.POS_NUM ) AS KU$_PART_COL_LIST_T )
, (SELECT VALUE (IPO)
FROM KU$_PARTOBJ_VIEW IPO
WHERE I.OBJ# = IPO.OBJ_NUM)
, (SELECT VALUE (OVPO)
FROM KU$_PARTOBJ_VIEW OVPO
WHERE T.BOBJ# = OVPO.OBJ_NUM)
, CAST(MULTISET(SELECT *
FROM KU$_PIOT_PART_VIEW IP
WHERE IP.BASE_OBJ_NUM = I.OBJ# ORDER BY IP.PART_NUM ) AS KU$_PIOT_PART_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_OV_TABPART_VIEW OVP
WHERE OVP.BOBJ_NUM = T.BOBJ# ORDER BY OVP.PART_NUM ) AS KU$_OV_TABPART_LIST_T )
FROM TAB$ T
, IND$ I
WHERE I.BO#=T.OBJ#
AND I.TYPE#=4 -- IOT INDEX
AND BITAND(T.PROPERTY
, 32)=32 -- PARTITIONED TABLE