This is a good Metalink document for troubleshooting issues with creation or refresh or maintenance of materialized views. MVIEW ‘ORA-‘ error diagnosis. For Materialized View CREATE or REFRESH (Doc ID 1087507.1) The diagnostic is listed by the MView’s ORA errors.