Re: Thanks!! What are the type#'s in obj$ ?

Jared,

It's quite easy to check:

alter session set sql_trace = true;
drop sequence s;
...
or better use 10046 trace with binds.
Then search for all occurrences of obj$ in trace file. Also you can set tracing on instance level in init.ora and see what SMON is performing during startup. From there you see that it executes a query finding all type# 10 obj$ entries, which do not have dependants (the negative dep tracking case.)

Generally all other base tables (like seg$, dependency$, etc..) get deleted the record(s), but obj$ is only updated to type 10. Thats the case with dropping synonyms, sequences, procedures, functions, probably several other DD objects as well, it's possible to trace it all.

But when dropping a segment (table, index) for example, then obj$ gets eventually deleted as well. (btw, I base my claims on tests on Oracle version is 9.2.0.1 on Win, don't know about previous versions)

Cheers,
Tanel.

> Interesting. I didn't realize that oracle would keep
> dropped objects as an unused type rather than delete them.
>
> Thanks,
>
> Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).