set line 200
col owner for a20
col tablespace_name for a10
col table_name for a20
col mb for 9999.99
select owner, tablespace_name,table_name,num_rows*avg_row_len/1024/1024 MB
from dba_tables
where table_name=upper('&table_name')
and owner=upper('&owner')