Re: KOTTD$ and KOTTB$

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.
>
>
>

--
http://www.freelists.org/webpage/oracle-l