Script to Finde the size of the table

SQL> select segment_name, sum(bytes)/(1024*1024) as SIZE_IN_MB from dba_extents
     where segment_type = 'TABLE'
     and
     segment_name = 'MY_TABLE'
     group by segment_name;