Hi ,

You are right.

But if I import the table which was exported with compress, then it will exactly take the number of blocks, may be some short fall will be there, I mean last block may not be filled up completely.

In this case if it takes 1 block, then I will be sure that the data is not more than 8K which is my DB_BLOCK_SIZE.

But if I select bytes from DBA_SEGMENT it still will show 2MB , which is INITIAL extent size.

Any way hope there is no way out, to find the same for Index. Thanks for your reply.