Oracle Database Discussions

Hi,

I have a schema with about 180 tables. The sizes of tables ranges from few hundred to millions of rows. There are two tablespace for these schema, one for actual data and the other for indexes ONLY. After loading entire data when I queried DBA_SEGMENTS table I found the size of index type space to be greater than table type. Is this correct? If yes then How is it that the size of part(index = few columns of table) of a table greater than size of actual table?.

select ((sum(bytes))/1024)/1024 "SIZE IN MB",tablespace_name,owner,segment_type from DBA_SEGMENTS group by tablespace_name,owner,segment_type

Thanks,

Imran,