Re: Dumb question again
Hello , try this select statement , it gives you
all table sizes in KB's order desc by size ....
database sysmaster ;
select systabnames.tabname, sysdbspaces.name,
round ( sum (sysextents.size)* 2/1024, 2 ) tsize
from systabnames, sysdbspaces, sysextents
where sysdbspaces.dbsnum = round(systabnames.partnum / (1048576),0)
and systabnames.dbsname = "eagle" # put your db name here !
and sysextents.tabname = systabnames.tabname
group by systabnames.tabname, sysdbspaces.name
order by 2, 3 desc
Mariusz Malogrosz
Susan Elliott (ISG) <SusanE@fclcis.co.nz> wrote in article
<6hhbpt$64j$1@news.xmission.com>...
>
> Howdy folks
>
> Could someone please tell me how to find out the actual size of a
> table.. i.e. table fred is 5 gig in size.
> I have looked at oncheck - pT, but it really doesn't make a lot of
> sense..(2 me)
>
> Any help would be greatly appreciated.
>
> Regards
> Suze.
>