Tuesday, 29 November 2011

To find the no of objects are running in the database

SQL> select count(object_name), object_type  from dba_objects group by object_type;

(or)

SQL> select count(object_name), object_type  from all_objects where owner='LIMS_ADMIN' group by object_type;(finding schema vice).

No comments:

Post a Comment