Thank you Gert , Srinivas...

Srinivas,
I have got few doubts which you may clarify... Did you find any invalidations of the packages/stored procs while renaming the TABLES ( Original Tables ). ?? Also Is it possible to rename MV to table and table to MV ????

Or you mean ( in your solution to the problem ) table means MV at all the places... I am a bit confused. Since you are already implemented , would you send me an eaxmple to my MAIL id or paste it here in the forum. I would like to see it in step by step in more meaningful manner, This is just a request to you and not a demand ..

Thanks a bunch again,