Re: Current Tables' Size

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 Wed Nov 22 2000 - 04:45:19 CST