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-29292: file rename operation failed

1 Answers  


ORA-00724: ALTER DATABASE CONVERT command has been de-supported

1 Answers  


ORA-00406: COMPATIBLE parameter needs to be string or greater

1 Answers  


ORA-28545: error diagnosed by Net8 when connecting to an agent

2 Answers  


ORA-09241: smsalo: error allocating SGA memory

1 Answers  






RMAN-06115: changed backup piece available

1 Answers  


ORA-01229: data file string is inconsistent with logs

1 Answers  


NNL-00274: server not started, errors follow

1 Answers  


ORA-30444: rewrite terminated by the sql analyzer

1 Answers  


TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC

1 Answers  


DRG-50945: Illegal phrase in query for theme index

1 Answers  


RMAN-08501: output filename=string recid=string stamp=string

1 Answers  


Categories