P.S. The description for the type# field in dba_objects is not in the fine manual but you can see it by doing a select text from dba_views where view_name = 'DBA_OBJECTS' ;
In general to find out information about the columns in a SYS table look at the source code for the corresponding DBA_VIEW, e.g. OBJ$ -> DBA_OBJECTS TAB$ -> DBA_TABLES IND$ -> DBA_INDEXES etc. > -----Original Message----- > From: Jacques Kilchoer > > > -----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).