Table Size

[jmodic]

Originally posted by abhaysk
1)

Select 
  Count(Distinct Substr(Rowid, 1, 15))*{Block_Size}/1024/1024 "Table Size in MB" 
from 
  {Table_Name}
;

I wonder what this query is supposed to tell you about the table size in MB.... More or less nothing. But we've been through that many times in this forum....