Originally posted by sjadhavdba Thanks julian,
In this case oracle shud upadate dictionary too with new name is it descripancy in oracle ???
Renaming MVs is a non-documented feature of Oracle. You should not use it.
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 .
In case the table on which the MV is based does not exist, you still have one option. Create a table with a same structure as the dropped table. Then you can run the command that I gave you in my first reply.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g