ERROR | cannot create a fast refresh materialized view from a complex query |
CAUSE | Neither ROWIDs and nor primary key constraints are supported for complex queries. |
ACTION | Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple materialized view. |