Oracle database error code ORA-12052 – cannot fast refresh materialized view string.string

Oracle Database Error Code ORA-12052 Description :
cannot fast refresh materialized view string.string
Error 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.

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»