VIEW: SYS.KU$_2NDTAB_INFO_VIEW

Source

View Text - Preformatted

select distinct
        o.obj#,
        o1.name,
        u1.name,
        o2.name,
        u2.name,
        ptts.ts_num,
        it.interface_version#,
        0
   from obj$ o, obj$ o1, obj$ o2, ind$ i, user$ u1, user$ u2, indtypes$ it,
        tab$ t, secobj$ s, ku$_ptable_ts_view ptts
   where o.obj#=s.secobj#
         AND o.obj#=t.obj#
         AND ptts.obj_num = o.obj#
         AND o1.obj#=s.obj#
         AND o1.obj# = i.obj#
         AND i.type# = 9
         AND o1.owner# = u1.user#
         AND i.indmethod# = it.obj#
         AND o2.obj# = it.implobj#
         AND o2.owner# = u2.user#
         AND bitand(i.property, 2) != 2         /* non-partitioned */
   UNION ALL
  select distinct
        o.obj#,
        o1.name,
        u1.name,
        o2.name,
        u2.name,
        ptts.ts_num,
        it.interface_version#,
        DECODE(BITAND (i.property, 512), 512, 64,0)+   /*0x200=iot di*/
        DECODE(BITAND(po.flags, 1), 1, 1, 0) +          /* 1 = local */
        DECODE(po.parttype, 1, 2, 2, 4, 0)    /* 1 = range, 2 = hash */
   from obj$ o, obj$ o1, obj$ o2, ind$ i, user$ u1, user$ u2,
        partobj$ po, indtypes$ it, tab$ t, secobj$ s, ku$_ptable_ts_view ptts
   where o.obj#=s.secobj#
         AND o.obj#=t.obj#
         AND ptts.obj_num = o.obj#
         AND o1.obj#=s.obj#
         AND o1.obj# = i.obj#
         AND i.type# = 9
         AND o1.owner# = u1.user#
         AND i.indmethod# = it.obj#
         AND o2.obj# = it.implobj#
         AND o2.owner# = u2.user#
         AND bitand(po.flags, 8) = 8            /* domain index */
         AND po.obj# = i.obj#
         AND bitand(i.property, 2) = 2          /* partitioned */

View Text - HTML Formatted

SELECT DISTINCT O.OBJ#
, O1.NAME
, U1.NAME
, O2.NAME
, U2.NAME
, PTTS.TS_NUM
, IT.INTERFACE_VERSION#
, 0
FROM OBJ$ O
, OBJ$ O1
, OBJ$ O2
, IND$ I
, USER$ U1
, USER$ U2
, INDTYPES$ IT
, TAB$ T
, SECOBJ$ S
, KU$_PTABLE_TS_VIEW PTTS
WHERE O.OBJ#=S.SECOBJ#
AND O.OBJ#=T.OBJ#
AND PTTS.OBJ_NUM = O.OBJ#
AND O1.OBJ#=S.OBJ#
AND O1.OBJ# = I.OBJ#
AND I.TYPE# = 9
AND O1.OWNER# = U1.USER#
AND I.INDMETHOD# = IT.OBJ#
AND O2.OBJ# = IT.IMPLOBJ#
AND O2.OWNER# = U2.USER#
AND BITAND(I.PROPERTY
, 2) != 2 /* NON-PARTITIONED */ UNION ALL SELECT DISTINCT O.OBJ#
, O1.NAME
, U1.NAME
, O2.NAME
, U2.NAME
, PTTS.TS_NUM
, IT.INTERFACE_VERSION#
, DECODE(BITAND (I.PROPERTY
, 512)
, 512
, 64
, 0)+ /*0X200=IOT DI*/ DECODE(BITAND(PO.FLAGS
, 1)
, 1
, 1
, 0) + /* 1 = LOCAL */ DECODE(PO.PARTTYPE
, 1
, 2
, 2
, 4
, 0) /* 1 = RANGE
, 2 = HASH */
FROM OBJ$ O
, OBJ$ O1
, OBJ$ O2
, IND$ I
, USER$ U1
, USER$ U2
, PARTOBJ$ PO
, INDTYPES$ IT
, TAB$ T
, SECOBJ$ S
, KU$_PTABLE_TS_VIEW PTTS
WHERE O.OBJ#=S.SECOBJ#
AND O.OBJ#=T.OBJ#
AND PTTS.OBJ_NUM = O.OBJ#
AND O1.OBJ#=S.OBJ#
AND O1.OBJ# = I.OBJ#
AND I.TYPE# = 9
AND O1.OWNER# = U1.USER#
AND I.INDMETHOD# = IT.OBJ#
AND O2.OBJ# = IT.IMPLOBJ#
AND O2.OWNER# = U2.USER#
AND BITAND(PO.FLAGS
, 8) = 8 /* DOMAIN INDEX */
AND PO.OBJ# = I.OBJ#
AND BITAND(I.PROPERTY
, 2) = 2 /* PARTITIONED */