> -----Original Message-----
> From: Barbara Baker [mailto:[EMAIL PROTECTED]
>
> Can anyone tell me in which fine manual I find what
> the types equate to in obj$
>
> I want to know what a type 10 object is:
>
> select obj#,name,type# from obj$ where obj#=288484;
>
> OBJ# NAME TYPE#
> ---------- -------------- ----------
> 288484 V$TEMPFILE 10
>
> (Solaris 2.6; Oracle 8.1.7.4)
The source code for dba_objects has a comment in the where clause describing type# 10
as 'non-existent'.
I've seen objects with that type# be created when you drop a synonym.
e.g.
SQL> create synonym x for y ;
Synonyme créé.
SQL> drop synonym x ;
Synonyme supprimé.
SQL> select name, type# from sys.obj$
2 where owner# = sys_context ('userenv', 'current_schemaid')
3 and name = 'X' ;
NAME TYPE#
------------------------------ ---------
X 10
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
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).
