sys@OINTEST>select namespace,object_type,count(*)
2 from (
3 select namespace,decode(o.type#, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
4 4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE',
5 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
6 11, 'PACKAGE BODY', 12, 'TRIGGER',
7 13, 'TYPE', 14, 'TYPE BODY',
8 19, 'TABLE PARTITION', 20, 'INDEX PARTITION', 21, 'LOB',
9 22, 'LIBRARY', 23, 'DIRECTORY', 24, 'QUEUE',
10 28, 'JAVA SOURCE', 29, 'JAVA CLASS', 30, 'JAVA RESOURCE',
11 32, 'INDEXTYPE', 33, 'OPERATOR',
12 34, 'TABLE SUBPARTITION', 35, 'INDEX SUBPARTITION',
13 40, 'LOB PARTITION', 41, 'LOB SUBPARTITION',
14 42, 'MATERIALIZED VIEW',
15 43, 'DIMENSION',
16 44, 'CONTEXT', 46, 'RULE SET', 47, 'RESOURCE PLAN',
17 48, 'CONSUMER GROUP',
18 51, 'SUBSCRIPTION', 52, 'LOCATION',
19 55, 'XML SCHEMA', 56, 'JAVA DATA',
20 57, 'SECURITY PROFILE', 59, 'RULE',
21 62, 'EVALUATION CONTEXT',
22 'UNDEFINED') object_type
23 from obj$ o
24 )
25 group by namespace,object_type;
NAMESPACE OBJECT_TYPE COUNT(*)
---------- ------------------ ----------
1 TYPE 502
1 VIEW 1941
1 TABLE 1326
1 LIBRARY 61
1 PACKAGE 302
1 SYNONYM 1668
1 FUNCTION 84
1 OPERATOR 2
1 SEQUENCE 464
1 PROCEDURE 181
1 UNDEFINED 133
1 NEXT OBJECT 1
1 TABLE PARTITION 150
2 TYPE BODY 22
2 PACKAGE BODY 294
3 TRIGGER 109
4 INDEX 1539
4 INDEX PARTITION 233
5 CLUSTER 10
8 LOB 93
10 QUEUE 8
24 RESOURCE PLAN 3
24 CONSUMER GROUP 4
38 EVALUATION CONTEXT 1