VIEW: SYS.INDEX_ORPHANED_ENTRY_V$

Source

View Text - Preformatted

select iu.name, iobj.name, iobj.subname, iobj.obj#,
       tu.name, tobj.name, tobj.subname, tobj.obj#, ioe.hidden
from user$ iu, obj$ iobj, index_orphaned_entry$ ioe,
     user$ tu, obj$ tobj
where iu.user# = iobj.owner# and iobj.obj# = ioe.indexobj#
  and tu.user# = tobj.owner#
  and ((iobj.type# = 1   /* index */
        and tobj.obj# = (select i.bo# from ind$ i where i.obj# = iobj.obj#))
      or
       (iobj.type# = 20  /* index partition */
        and tobj.obj# = (select i.bo# from ind$ i, indpart$ ip
                           where ip.obj# = iobj.obj# and ip.bo# = i.obj#))
      )
  and (iobj.owner# = userenv('SCHEMAID')
       or
       exists (select null from v$enabledprivs
                 where priv_number in (-72 /* ALTER ANY INDEX */))
      )

View Text - HTML Formatted

SELECT IU.NAME
, IOBJ.NAME
, IOBJ.SUBNAME
, IOBJ.OBJ#
, TU.NAME
, TOBJ.NAME
, TOBJ.SUBNAME
, TOBJ.OBJ#
, IOE.HIDDEN FROM USER$ IU
, OBJ$ IOBJ
, INDEX_ORPHANED_ENTRY$ IOE
, USER$ TU
, OBJ$ TOBJ WHERE IU.USER# = IOBJ.OWNER#
AND IOBJ.OBJ# = IOE.INDEXOBJ#
AND TU.USER# = TOBJ.OWNER#
AND ((IOBJ.TYPE# = 1 /* INDEX */
AND TOBJ.OBJ# = (SELECT I.BO#
FROM IND$ I
WHERE I.OBJ# = IOBJ.OBJ#)) OR (IOBJ.TYPE# = 20 /* INDEX PARTITION */
AND TOBJ.OBJ# = (SELECT I.BO#
FROM IND$ I
, INDPART$ IP
WHERE IP.OBJ# = IOBJ.OBJ#
AND IP.BO# = I.OBJ#)) )
AND (IOBJ.OWNER# = USERENV('SCHEMAID') OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-72 /* ALTER ANY INDEX */)) )