Re: Current Tables' Size

This will require an analyze on the table.

"Lee" <lstrode_at_TAMPABAY.RR.COM> wrote in message news:3tNS5.55830$vc3.10785011_at_typhoon.tampabay.rr.com...
> One method is:
>
> select ((num_rows*avg_row_length)/1024/1024) as "Approx Size in MB"
> from all_tables
> where table_name = &TBL_NAME.;
>
> This is an appoximate, not sure how to do this for indexes though.
>
> "Rayfil Cheung" <rayfilcheung_at_hket.com> wrote in message
> news:3A1B848E.25E76863_at_hket.com...
> > How can I check the current tables' size. Thank you.
> >
> >
>
>
Received on Sat Dec 02 2000 - 22:01:41 CST