ORA-12015

Error: ORA-12015: cannot create a fast refresh materialized view from a complex query

Causa: Neither ROWIDs nor primary key constraints are supported for complex queries.

Acción: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple materialized view.