Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


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.



Action:


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.

No comments:

Post a Comment

Thanks for your comment.