hi,

thanks a lot for your mail. i ran this query of yours and found that the size of only one record in the following table "TB_PROPERTIES_TEXT" will be 160 bytes and it would be 152MB for 1 million records. Pls mention about how oracle is reaching upto this figure of 160 Bytes. I am providing the table structure so that you can do the exact calculations based on the column datatype.

TB_PROPERTIES_TEXT
-----------------------------
COMPANYID number
OBJECTTYPEID number
OBJECTID number
PROPERTYID number
SEQUENCE number
VALUEPROPERTY varchar2(50)

Pls also mention about how to calculate the index sizes for a given table.

thanks once again

Parijat Paul