>-----Original Message-----
>From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
>
> ...
>Where i can check to know the desc for all the type#?. (N.B. from sys.obj$)
Look at the source code for the dba_objects view. In SQL*Plus:
set long 5000
set pagesize 0
select text
from dba_views
where owner = 'SYS'
and view_name = 'DBA_OBJECTS' ;
Have a look at the source code for some other dba_ views while you're at it (e.g. DBA_TABLES, DBA_INDEXES, DBA_SEGMENTS), it can be very instructive.
