Re: Space Used by Table Name

column TABLE_NAME format a30
column SIZE format 99999

Select segment_name "TABLE_NAME",segment_type,sum(bytes)/1024/1024 "SIZE"   from dba_Segments where segment_type in ('TABLE','INDEX')   and owner = 'yourschemaname'
  group by segment_name,segment_type
/

Hope you don't get a flood of the same responses =8-/

Jeff Herrick
Jeff Herrick & Associates

On Tue, 20 Jun 2000, Christine Turner wrote:

> Hello All,
>
> I know this will sound simple.....but is there a way to find out "space
> used" by table? Have a weird situation where one of my clients wants to
> know how much space (in meg) is being used by each table within the
> database.
>
> Thanks In Advance....
> Christine Turner
> Database Administrator
> IPS-Sendero
> Scottsdale, Arizona
> Phone: (800) 321-6899 ext. 3286
> Fax: (480) 946-8224
> E-mail: christine.turner_at_ips-sendero.com
>
> --
> Author: Christine Turner
> INET: Christine.Turner_at_IPS-Sendero.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 20 2000 - 18:54:39 CDT