Re: table size

From: Thierry Poels <Thierry.Poels_at_vab.be>
Date: Wed, 28 Oct 1998 12:22:46 +0100
Message-ID: <7172da$nf6$1@news1.skynet.be>

Hi,

User_Tables, DBA_Tables and All_Tables only show the initial extent and the current next extent, but don't show the current size of your table. You need to sum the extents in DBA_Extents (or ALL_..., User_...) :

Select Segment_Name, Sum(bytes), Sum(Blocks) From User_Extents
where Segment_Name = 'your_table_name'

greetings,
Thierry Poels ( Thierry.Poels_at_vab.be ) DBA & Unix System Manager for VTB-VAB
http://www.vab.be

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:22:46 CST