Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query for counts of all_objects

user12050217Nov 8 2012 — edited Nov 8 2012
Oracle 11.2.0.1

I have to generate the count of all types of objects in below style.
USERNAME	TABLES		INDEXES		MVS		PROCEDURES	FUNCTIONS	CLUSTER	
USER1		    10	              5		  1		        20	        5
USER2						  2
USER3												     10

TOTAL               10                5           3                     20               5           10
Here count of all_objects should match with sum of total column i.e. 10+5+3+20+5+10.

Kindly help me, how do I generate above output.

Thank you.
This post has been answered by Girish Sharma on Nov 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2012
Added on Nov 8 2012
#general-database-discussions
5 comments
284 views