Hi! Check http://www.jlcomp.demon.co.uk/faq/non_exist.html for explanation.
Also, I'll include a little sample, how they might occur. Cheers, Tanel. SQL> create table a (b number); Table created. SQL> create synonym s for a; Synonym created. SQL> select name, type# from obj$ where name = 'A'; NAME TYPE# ------------------------------ ---------- A 2 A 2 SQL> select name, type# from obj$ where name = 'S'; NAME TYPE# ------------------------------ ---------- S 5 SQL> drop synonym s; Synonym dropped. SQL> select name, type# from obj$ where name = 'S'; NAME TYPE# ------------------------------ ---------- S 10 SQL> startup force ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> select name, type# from obj$ where name = 'S'; no rows selected SQL> ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 2:49 AM > > 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) > Thanks! > > Barb > BAARF party number 20 > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Barbara Baker > 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). > -- 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).
