Re: Table's size
From: Imprecise <f_puhan_at_precise.com>
Date: Fri, 14 Jun 2002 15:38:29 -0400
Message-ID: <f_puhan-4D382B.15382914062002_at_vienna7.his.com>
Date: Fri, 14 Jun 2002 15:38:29 -0400
Message-ID: <f_puhan-4D382B.15382914062002_at_vienna7.his.com>
In article <f3oO8.56$xB2.74_at_news-srv1.fmr.com>, "Chris" <chris_at_nospam.com> wrote:
> Hi,
>
> Is there a simple way to get the size of a table on MG (or even on Kb) -
> Something that let's me know that Table X is so many MG
>
> Thanks
> Chris
SELECT
round(sum(bytes)/1024/1024,2) "Size in MB"
FROM
DBA_EXTENTS
WHERE
SEGMENT_NAME = upper('&&Table_Name')
/
-- The underscore character does not belong in my address. You know the drill... *** Anyone sufficiently smart enough to configure and use USEnet for research should be smart enough to Read The Freakin' Documentation!Received on Fri Jun 14 2002 - 21:38:29 CEST