Re: Is there a way to get byte counts of actual data stored in a table?

g vose wrote:

> I am looking for a way to see the actual size of a table in bytes
> used.
> I can see the size being used for the DataBase and I can see the
> allocated space for the table but I can not tell the actual space
> being used by a table.
> Does anyone have any suggestions?

Run analyze:

SQL> analyze table schemaname.tablename compute;

Then look in user_tables.

Daniel A. Morgan Received on Tue Jul 17 2001 - 14:13:43 CDT