Re: KOTTD$ and KOTTB$
- From: Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Thu, 06 Nov 2008 08:23:49 -0600
kottd$ table is an object table created with
create table kottd$ of kottd oid '00000000000000000000000000010001'
kottd is an object type..
I think, KO module deals with Objects and types.
Cheers
Riyaj
blog: http://orainternals.wordpress.com
Jared Still wrote:
Here's a query that will show objects associated with entries in kottd$
select
u.name <http://u.name> user_name
,o.name <http://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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
