VIEW: SYS.DBA_SECONDARY_OBJECTS

Source

View Text - Preformatted

select u.name, o.name, u1.name, o1.name, decode(s.spare1, 0, 'FROM INDEXTYPE',
                                                1, 'FROM STATISTICS TYPE')
from   sys.user$ u, sys.obj$ o, sys.user$ u1, sys.obj$ o1, sys.secobj$ s
where  s.obj# = o.obj# and o.owner# = u.user# and
       s.secobj# = o1.obj#  and  o1.owner# = u1.user#

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, U1.NAME
, O1.NAME
, DECODE(S.SPARE1
, 0
, 'FROM INDEXTYPE'
, 1
, 'FROM STATISTICS TYPE') FROM SYS.USER$ U
, SYS.OBJ$ O
, SYS.USER$ U1
, SYS.OBJ$ O1
, SYS.SECOBJ$ S WHERE S.OBJ# = O.OBJ#
AND O.OWNER# = U.USER# AND S.SECOBJ# = O1.OBJ#
AND O1.OWNER# = U1.USER#