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.
