Re : table size

Look into the dba_extents table. The segment name is the table name. Produce a sum
of the blocks field or bytes field for all extents of that name (same owner + same segment type).

The ALL_TABLES or USER_TABLES or DBA_TABLES or TABS views that someone mentionned, will show you
some info only if the statistics were calculated (estimate or compute options).

Sylvain Leclerc, DBA
INT Systèmes d'information
Membre du Groupe Magrit
sleclerc_at_magrit.com

> -----Original Message-----
> From: Fei Sha [SMTP:shaf_at_prism.uvsq.fr]
> Posted At: Tuesday, October 27, 1998 7:20 AM
> Posted To: server
> Conversation: table size
> Subject: table size
>
> Hi everyone,
> How to know the size of a table in Mb or number of blocks?
> Thank!
>
> Fei
>
>
Received on Wed Oct 28 1998 - 07:06:31 CST