Thanx for your support Julian.So can we use deallocate unused clause to free up the space?but still I had already moved that whole user schema in to another tablespace.So what can be done to resize it?
any other option?