VIEW: SYS.EXU9DOI

Source

View Text - Preformatted

SELECT  ind$.obj#, indo$.owner#, ind$.spare4, o2$.name, u2$.name,
                o3$.name, u3$.name, it$.interface_version#, it$.property, 0
        FROM    sys.ind$ ind$, sys.obj$ indo$, sys.obj$ o2$, sys.obj$ o3$,
                sys.user$ u2$, sys.user$ u3$, sys.indtypes$ it$
        WHERE   ind$.type# = 9 AND                           /* Domain Index */
                ind$.indmethod# = it$.obj#  AND
                ind$.obj# = indo$.obj# AND
                it$.obj# = o2$.obj# AND
                it$.implobj# = o3$.obj# AND
                o2$.owner# = u2$.user# AND
                o3$.owner# = u3$.user# AND
                BITAND(ind$.property, 2) != 2                 /* partitioned */
      UNION ALL         /* Grab domain indexes that have partition info also */
        SELECT  ind$.obj#, indo$.owner#, ind$.spare4, o2$.name, u2$.name,
                o3$.name, u3$.name, it$.interface_version#, it$.property,
                DECODE(BITAND (ind$.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    sys.ind$ ind$, sys.obj$ indo$, sys.obj$ o2$, sys.obj$ o3$,
                sys.user$ u2$, sys.user$ u3$, sys.indtypes$ it$,
                sys.partobj$ po$
        WHERE   ind$.type# = 9 AND
                ind$.indmethod# = it$.obj# AND
                ind$.obj# = indo$.obj# AND
                it$.obj# = o2$.obj# AND
                it$.implobj# = o3$.obj# AND
                o2$.owner# = u2$.user# AND
                o3$.owner# = u3$.user# AND
                BITAND(po$.flags, 8) = 8 AND
                po$.obj# = ind$.obj# AND
                BITAND(ind$.property, 2) = 2                  /* partitioned */

View Text - HTML Formatted

SELECT IND$.OBJ#
, INDO$.OWNER#
, IND$.SPARE4
, O2$.NAME
, U2$.NAME
, O3$.NAME
, U3$.NAME
, IT$.INTERFACE_VERSION#
, IT$.PROPERTY
, 0
FROM SYS.IND$ IND$
, SYS.OBJ$ INDO$
, SYS.OBJ$ O2$
, SYS.OBJ$ O3$
, SYS.USER$ U2$
, SYS.USER$ U3$
, SYS.INDTYPES$ IT$
WHERE IND$.TYPE# = 9
AND /* DOMAIN INDEX */ IND$.INDMETHOD# = IT$.OBJ# AND IND$.OBJ# = INDO$.OBJ# AND IT$.OBJ# = O2$.OBJ# AND IT$.IMPLOBJ# = O3$.OBJ# AND O2$.OWNER# = U2$.USER# AND O3$.OWNER# = U3$.USER# AND BITAND(IND$.PROPERTY
, 2) != 2 /* PARTITIONED */ UNION ALL /* GRAB DOMAIN INDEXES THAT HAVE PARTITION INFO ALSO */ SELECT IND$.OBJ#
, INDO$.OWNER#
, IND$.SPARE4
, O2$.NAME
, U2$.NAME
, O3$.NAME
, U3$.NAME
, IT$.INTERFACE_VERSION#
, IT$.PROPERTY
, DECODE(BITAND (IND$.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 SYS.IND$ IND$
, SYS.OBJ$ INDO$
, SYS.OBJ$ O2$
, SYS.OBJ$ O3$
, SYS.USER$ U2$
, SYS.USER$ U3$
, SYS.INDTYPES$ IT$
, SYS.PARTOBJ$ PO$
WHERE IND$.TYPE# = 9 AND IND$.INDMETHOD# = IT$.OBJ# AND IND$.OBJ# = INDO$.OBJ# AND IT$.OBJ# = O2$.OBJ# AND IT$.IMPLOBJ# = O3$.OBJ# AND O2$.OWNER# = U2$.USER# AND O3$.OWNER# = U3$.USER# AND BITAND(PO$.FLAGS
, 8) = 8 AND PO$.OBJ# = IND$.OBJ# AND BITAND(IND$.PROPERTY
, 2) = 2 /* PARTITIONED */