Skip to Main Content

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!

Calculate total number of rows per schema.

MaahjoorMay 14 2013 — edited May 16 2013
Dear all,

i am using oracle database 10g against windows 2003 server.

i want to calculate total number of rows in a schema.
i have only one method to just select count(*) from each table inside each schema.
as there any possible query which could calculate total number of rows in a schema?


Thanks.

Edited by: Maahjoor on May 13, 2013 11:21 PM
This post has been answered by Alvaro on May 14 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2013
Added on May 14 2013
14 comments
2,295 views