Try....

select owner,count(*) from dba_objects
group by owner;

Hope this helps.

Regards

Deepak
----- Original Message -----
From: "Vasudev Venugopal C "
<oracledba-ezmlmshield-x47670855.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, August 05, 2004 8:25 AM
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