sys.obj$, type# desc

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Fri, 19 Oct 2001 08:18:17 -0700
Message-ID: <F001.003AFE9F.20011019081023@fatcity.com>

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. Received on Fri Oct 19 2001 - 10:18:17 CDT