RE: sys.obj$, type# desc

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:NIRMALK_at_qtel.com.qa]
> Sent: Friday, October 19, 2001 11:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: sys.obj$, type# desc
>
> hI gurus'
>
> SYSTEM_at_ORCLSVR.QTEL.COM.QA>;
> 1* select obj#, name, type# from sys.obj$ where name like 'DBA%' and
> rownum < 4
> SYSTEM_at_ORCLSVR.QTEL.COM.QA> /
>
> OBJ# NAME TYPE#
> --------- ------------------------------ ---------
> 1149 DBA_ROLES 4
> 1150 DBA_ROLES 5
> 1151 DBA_PROFILES 4
>
> SYSTEM_at_ORCLSVR.QTEL.COM.QA>
>
> 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: kirti.deshpande_at_verizon.com

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: ListGuru_at_fatcity.com (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).