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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-17507: I/O request size string is not a multiple of logical block size

1 Answers  


NID-00431: DBNEWID - Reversion completed.

1 Answers  


ORA-12039: unable to use local rollback segment "string"

1 Answers  


TNS-00232: Unable to setup connection

1 Answers  


ORA-36637: (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.

1 Answers  






ORA-24323: value not allowed

1 Answers  


DRG-13200: failed to load dictionary file string

1 Answers  


LPX-00282: document cannot have both internal/external and shared DTDs

1 Answers  


ORA-18008: cannot find OUTLN schema

1 Answers  


PLS-00151: Expression or Variable is an illegal type to PLS/QL: string

1 Answers  


TNS-12211: TNS:needs PREFERRED_CMANAGERS entry in TNSNAV.ORA

1 Answers  


TNS-12590: TNS:no I/O buffer

1 Answers  


Categories