ora-12060 shape of prebuilt table does not match definition query
An mview becoming invalid does not mean it will not retain old data. You can still query the mview. Actually an mview with invalid status means it has old data and it is not in sync with the master table.
We were seeing the same behavior. in 9.2 and found Metalink note 264036.1 which says:
"This is expected behavior. When there is a DML on the master table, all the MVs based on this table are marked as INVALID. Though the status is INVALID, you will be able to query the mview.
However, the query on MV will not return latest update done in master table unless MV is refreshed
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10130206/viewspace-616473/，如需转载，请注明出处，否则将追究法律责任。