Re: sys.obj$, type# desc

1 INDEX
2 TABLE
3 CLUSTER
4 VIEW
5 SYNONYM
6 SEQUENCE
7 PROCEDURE
8 FUNCTION
9 PACKAGE
10 NON-EXISTENT
11 PACKAGE BODY
12 TRIGGER
13 TYPE
14 TYPE BODY
19 TABLE PARTITION
20 INDEX PARTITION
21 LOB
22 LIBRARY
23 DIRECTORY
24 QUEUE
25 IOT
26 REPLICATION OBJECT GROUP
27 REPLICATION PROPAGATOR
28 JAVA SOURCE
29 JAVA CLASS
30 JAVA RESOURCE
31 JAVA JAR
32 INDEXTYPE
33 OPERATOR
34 TABLE SUBPARTITION
35 INDEX SUBPARTITION Richard Ji

>>> NIRMALK_at_qtel.com.qa 10/19/01 12:10PM >>>
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.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Ji
  INET: rji_at_exenet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).