SQL & PL/SQL

Hi All,

Could any one tel me how to find the size of an IOT table. I am not able find IOT table information in user_segments table.

But i am using the index name which is created on IOT table to figure out the size .am i using correct way to find out the size of the IOT table , if not please let me know .

Below is the Query .

select sum(bytes)/1024/1024/1024 ,segment_name

from user_segments where segment_name='<name of the an index with is created on IOT table>'

group by segment_name

Thanks

Sree