Re: atual data size...

select NUM_ROWS * AVG_ROW_LEN
from all_tables
where table_name = '<your table>';

This will give a good estimate of used space provided you have analyzed the table in question.

HTH
Anthony Hogan
hogananthony_at_hotmail.com Received on Wed Jan 09 2002 - 08:32:25 CST