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
>>> [EMAIL PROTECTED] 10/19/01 12:10PM >>>
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Richard Ji
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
