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>


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-l
Received on Wed Nov 05 2008 - 18:23:01 CST

Original text of this message