Re: Retrieving Oracle Table size in Bytes

From: Mark Wagoner <mwagoner_at_iac.net>
Date: Wed, 31 Jan 2001 13:48:59 -0500
Message-ID: <959mmr$383$1@genma.iac.net>

You need to sum all the segment sizes for the table. Use dba_extents for the table/segment name. This will give you only the allocated space, since an extent is pre-allocated, not necessarily used.

<newopt_at_my-deja.com> wrote in message news:959kuc$omq$1_at_nnrp1.deja.com...
> I looked in dba_tables for an oracle table size in bytes but didn't see
> a column that reflects the size of the table in bytes.
>
> Where can this information be retrieved from?
>
> Thanks
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Jan 31 2001 - 12:48:59 CST