Thursday 16 February 2012

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