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!

to know the size of multiple tables

Dan AMar 14 2012 — edited Mar 14 2012

Hi Oracle Dons:

I need to check the size of multiple tables via a SQL query. The way I would do this for a single table is

select bytes from dba_segments where segment_name='table_name';

But I need to do this for about 4 dozen tables.

Can someone point me along the right corridor?

Thanks.

RHLE 5
11.2.0.1

This post has been answered by sb92075 on Mar 14 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2012

Added on Mar 14 2012

#general-database-discussions

5 comments

3,308 views