Originally posted by sjadhavdba
you have solved my problem but any explaination pl.
Someone has renamed the MV from OLD_NAME to VIRU. Oracle still know is as OLD_NAME. You run drop MV VIRU, Oracle checks for such a MV, doesn't find one, reports to you MV VIRU not found. That's it :-)