Re: Table and schema current size.

"Peter Shvets" <pshvets_at_powermarket.com> wrote in message news:9hamoe$1rlg$1_at_news.mainstreet.net...
> Hello, dear friends.
> I need to find out how big is every single table in the schema I have
 as
> well as the size of the schema itself.

Define "how big" and "size"... :-)

Seriously, perhaps something like this is what you were asking for (usage is on ones own risk, of course):

Tables #1 (run this and then run the sql it produces): select 'select count(*) from '||table_name||';' from user_tables;

Tables #2 (includes views and synonyms also): select 'select count(*) from '||table_name||';' from cat;

Schemas:
select count(*) "object count" from user_objects; select owner, count(*) "object count" from dba_objects group by owner;

Bonus:
select object_type, count(*) from user_objects group by object_type;

Note that not every type of object can be a schema object.

Regards
/Fad Received on Tue Jun 26 2001 - 15:12:02 CDT