Re: KOTTD$ and KOTTB$
From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 5 Nov 2008 16:23:01 -0800
Message-ID: <bf46380811051623y6712f0d1v94815f70a515f76c@mail.gmail.com>
Date: Wed, 5 Nov 2008 16:23:01 -0800
Message-ID: <bf46380811051623y6712f0d1v94815f70a515f76c@mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 05 2008 - 18:23:01 CST