Re: Oracle field size, take 2

Hi,

To obtain the size of a table, you can run the analyze command against the table, which will tell you the average row size, the number of rows, where the High Water Mark is (which states the highest block ever used), the number of empty blocks.

All of this can be found on the DBA_TABLES / USER_TABLES.

Hope this helps,
Andrew

Colinou wrote:

> Hey there,
>
> I would like (correction, my boss wants) to get the size of an Oracle
> table.
>
> Since, I'm pretty new to SQL, could anyone help?
>
> Thanx!
>
> Nr
Received on Fri May 07 1999 - 20:17:28 CDT