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@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 - 14:38:29 CDT