RE: sys.obj$, type# desc

>-----Original Message-----
>From: Nirmal Kumar Muthu Kumaran [mailto:NIRMALK_at_qtel.com.qa]
>
> ...
>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. Received on Fri Oct 19 2001 - 14:26:35 CDT