Hi,
I've a table which holds around one lacs of data. I need to know how much size does it requires in table_space for the table.
How do i calculate the size which is required by this table to be allocated for the tablespace?
currently, i'm using the following query (sql plus 9i)
select num_rows,avg_row_len,num_rows*avg_row_len from user_tables where table_name='<TABLE_NAME>';
Regards,