Oracle Solution for Error ora-12052

ORA-12052: cannot fast refresh materialized view string.string

What triggered the Error:

Either ROWIDs of certain tables were missing in the definition or the inner table of an outer join did not have UNIQUE constraints on join columns.

What should we do to fix it:

Specify the FORCE or COMPLETE option. If this error is got during creation, the materialized view definition may have be changed. Refer to the documentation on materialized views.