Nirmal, Type# 4 is a view Type# 5 is a synonym.
Look in sql.bsq file for more info... HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -----Original Message----- > From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 11:10 AM > To: Multiple recipients of list ORACLE-L > Subject: sys.obj$, type# desc > > hI gurus' > > [EMAIL PROTECTED]>; > 1* select obj#, name, type# from sys.obj$ where name like 'DBA%' and > rownum < 4 > [EMAIL PROTECTED]> / > > OBJ# NAME TYPE# > --------- ------------------------------ --------- > 1149 DBA_ROLES 4 > 1150 DBA_ROLES 5 > 1151 DBA_PROFILES 4 > > [EMAIL PROTECTED]> > > Hope that type# 4, refers 'SYNONYMS'. what is the object whic are refered > by type# 5?.(Is't view?) > > Where i can check to know the desc for all the type#?. > > > Regards, > Nirmal. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
