Thanks julian,
In this case oracle shud upadate dictionary too with new name is it descripancy in oracle ???

And what if this solution does not work for similar situations how to delete user containing that MV forcefully.

Becaz " drop user xyz cascade ; " does not work .