오라클 DB 오브젝트 현황표 만들기
SQL> SELECT owner, object_type, count(*) from dba_objects
2 group by owner, object_type
3 order by owner , object_type
4 ;
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
CTXSYS FUNCTION 5
CTXSYS INDEX 46
CTXSYS INDEXTYPE 4
CTXSYS LIBRARY 1
CTXSYS LOB 1
CTXSYS OPERATOR 6
CTXSYS PACKAGE 71
CTXSYS PACKAGE BODY 58
CTXSYS PROCEDURE 2
CTXSYS SEQUENCE 3
CTXSYS TABLE 37
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
CTXSYS TYPE 44
CTXSYS TYPE BODY 7
CTXSYS VIEW 54
DBSNMP INDEX 10
DBSNMP PACKAGE 3
DBSNMP PACKAGE BODY 3
DBSNMP SEQUENCE 2
DBSNMP TABLE 21
DBSNMP TYPE 6
DBSNMP VIEW 1
DMSYS FUNCTION 12
OWNER OBJECT_TYPE COUNT(*)
------------------------------ ------------------- ----------
DMSYS INDEX 2
DMSYS LIBRARY 6
DMSYS PACKAGE 27
DMSYS PACKAGE BODY 23
DMSYS PROGRAM 9
DMSYS SEQUENCE 1
DMSYS TABLE 2
DMSYS TYPE 94
DMSYS TYPE BODY 12
DMSYS VIEW 1
EDWUSER SYNONYM 230