Re: KOTTD$ and KOTTB$
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- Date: Wed, 5 Nov 2008 16:23:01 -0800
Here's a query that will show objects associated with entries in kottd$
select
u.name user_name
,o.name object_name
,case
when o.type# = 13 then 'TYPE'
when o.type# = 14 then 'TYPE BODY'
else 'UNKNOWN'
end as obj_type
from kottd$ kd, obj$ o, user$ u
where o.oid$ = sys_nc_oid$
and u.user# = o.owner#
/
The kott% tables appear to be the underlying DD tables for types.
Other related posts:
