Title: 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.

Reply via email to