VIEW: SYS.KU$_DOMIDX_PLSQL_VIEW

Source

View Text - Preformatted

select i.obj#,
        sys.dbms_metadata.get_domidx_metadata(o.name, u.name,
                o2.name, u2.name, i.ts#, it.interface_version#, 0)
   from obj$ o, obj$ o2, ind$ i, user$ u, user$ u2, indtypes$ it
   where i.type# = 9
         AND o.obj# = i.obj#
         AND o.owner# = u.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 i.obj#,
        sys.dbms_metadata.get_domidx_metadata(o.name, u.name,
                o2.name, u2.name, i.ts#,
                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$ o2, ind$ i, user$ u, user$ u2, partobj$ po,
        indtypes$ it
   where i.type# = 9
         AND o.obj# = i.obj#
         AND o.owner# = u.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 I.OBJ#
, SYS.DBMS_METADATA.GET_DOMIDX_METADATA(O.NAME
, U.NAME
, O2.NAME
, U2.NAME
, I.TS#
, IT.INTERFACE_VERSION#
, 0)
FROM OBJ$ O
, OBJ$ O2
, IND$ I
, USER$ U
, USER$ U2
, INDTYPES$ IT
WHERE I.TYPE# = 9
AND O.OBJ# = I.OBJ#
AND O.OWNER# = U.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 I.OBJ#
, SYS.DBMS_METADATA.GET_DOMIDX_METADATA(O.NAME
, U.NAME
, O2.NAME
, U2.NAME
, I.TS#
, 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$ O2
, IND$ I
, USER$ U
, USER$ U2
, PARTOBJ$ PO
, INDTYPES$ IT
WHERE I.TYPE# = 9
AND O.OBJ# = I.OBJ#
AND O.OWNER# = U.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 */