Tim, Ric, Brandon, Niall, rjamya: Thank you for your help I have searched the metalink (should have done it before posting) and found the bug 4771672 0 differences in dba_extents and dba_segments after parallel create index (my indices are all parallelized): If an index is created in parallel, the number of extents is reported differently on DBA_EXTENTS and DBA_SEGMENTS. This is happening only for larger indexes. According to this document there is no workaround. The version in the document is 10.1.0.1. My database is 10.2.0.2 I need to check whether this is supposed to be fixed in 10.2.0.X Thank you all again thank you Gene Gurevich -- //www.freelists.org/webpage/oracle-l