I have the feeling someone has been renaming materialized views :-)

Ask around from which table the renamed MV was recreated from. Say the table is called XYZ.

Then run:

Code:
create snapshot VIRU on prebuilt table as select * from XYZ;
Then drop it.

In 9i, it is impossible to rename MVs.