ORA-12015: cannot create a fast refresh materialized view from a complex query
What triggered the Error:
Neither ROWIDs and nor primary key constraints are supported for complex queries.What should we do to fix it:
Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple materialized view.