VIEW: SYS.DBA_INDEXTYPES

Source

View Text - Preformatted

select u.name, o.name, u1.name, o1.name, i.interface_version#, t.version#,
io.opcount, decode(bitand(i.property, 48), 0, 'NONE', 16, 'RANGE', 32, 'LOCAL     '),
decode(bitand(i.property, 2), 0, 'NO', 2, 'YES'),
decode(bitand(i.property, 1024), 0, 'USER_MANAGED', 1024, 'SYSTEM_MANAGED')
from sys.indtypes$ i, sys.user$ u, sys.obj$ o,
sys.user$ u1, (select it.obj#, count(*) opcount from
sys.indop$ io1, sys.indtypes$ it where
io1.obj# = it.obj# and bitand(io1.property, 4) != 4
group by it.obj#) io, sys.obj$ o1,
sys.type$ t
where i.obj# = o.obj# and o.owner# = u.user# and
u1.user# = o.owner# and io.obj# = i.obj# and
o1.obj# = i.implobj# and o1.oid$ = t.toid

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, U1.NAME
, O1.NAME
, I.INTERFACE_VERSION#
, T.VERSION#
, IO.OPCOUNT
, DECODE(BITAND(I.PROPERTY
, 48)
, 0
, 'NONE'
, 16
, 'RANGE'
, 32
, 'LOCAL ')
, DECODE(BITAND(I.PROPERTY
, 2)
, 0
, 'NO'
, 2
, 'YES')
, DECODE(BITAND(I.PROPERTY
, 1024)
, 0
, 'USER_MANAGED'
, 1024
, 'SYSTEM_MANAGED') FROM SYS.INDTYPES$ I
, SYS.USER$ U
, SYS.OBJ$ O
, SYS.USER$ U1
, (SELECT IT.OBJ#
, COUNT(*) OPCOUNT FROM SYS.INDOP$ IO1
, SYS.INDTYPES$ IT WHERE IO1.OBJ# = IT.OBJ#
AND BITAND(IO1.PROPERTY
, 4) != 4 GROUP BY IT.OBJ#) IO
, SYS.OBJ$ O1
, SYS.TYPE$ T WHERE I.OBJ# = O.OBJ#
AND O.OWNER# = U.USER# AND U1.USER# = O.OWNER#
AND IO.OBJ# = I.OBJ# AND O1.OBJ# = I.IMPLOBJ#
AND O1.OID$ = T.TOID