Re: table size

From: Vincent Roquencourt <vroquencout_at_businessobjects.com>
Date: Wed, 28 Oct 1998 12:45:24 +0100
Message-ID: <71709e$58t$1@news.businessobjects.com>

Hi,
take a look at the dba_extents view where you can get your information , as :

select sum(bytes) /1024/1024 , sum(blocks) from dba_extents
where segment_name='your table name'

it wiil give you the size used by your table...

Hope it'll help you..

Fei Sha wrote in message <714dvs$g93$1_at_venus.uvsq.fr>...
>Hi everyone,
> How to know the size of a table in Mb or number of blocks?
>Thank!
>
>Fei
>
>
>
Received on Wed Oct 28 1998 - 05:45:24 CST