Do you just want the number of objects? If so

SELECT owner, COUNT(object_name)
FROM dba_objects
GROUP BY owner


Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Vasudev Venugopal C
[mailto:oracledba-ezmlmshield-x47670855.[Email address protected]
Sent: Wednesday, August 04, 2004 9:16 PM
To: LazyDBA Discussion
Subject: Schema and objects' urgent

Hi guru's

I want the extract the schema and the objects in that schema, please help is
in getting the scripts as I need this information for 30 database. The out
put should be in this format.

Schema no of objects

Sys

System

Please help me it is urgent...

Vasu.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to
these terms:http://www.lazydba.com/legal.html







Oracle LazyDBA home page