Hai Vishal,

I had a user before with default tablespace which is related to this datafile.now I changed that user to another tablespace and moved all its contents.So obviously there shouldn't be any problem now.After coalescing the tablespace surely the free space should be merged up and be summed up to fewer blocks,right?But why is that not happenning.
why the coalesce is not showing any effect on my tablespace?
Since the datafile size is 2.5gb,I tried to resize it very near ti its size like 2.2gb also but invain.help me.

Regards,
Niranjan.