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

LSX-00112: facet "~S" duplicated

1 Answers  


ORA-25148: ONLINE option not permitted

1 Answers  


TNS-04071: Connections closed successfully. Number closed: number.

1 Answers  


ORA-01075: you are currently logged on

1 Answers  


ORA-36179: (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.

1 Answers  






ORA-25465: variable name not specified

1 Answers  


ORA-39751: partitioned table on both sides of PARTITIONED OUTER JOIN is not supported

1 Answers  


ORA-00603: ORACLE server session terminated by fatal error

2 Answers  


ORA-32100: operation invalid on transient object

1 Answers  


TNS-01408: Instance "string", status string, has string handler(s) for this service...

1 Answers  


ORA-32834: Messaging Gateway agent user has not been set

1 Answers  


ORA-39030: invalid file type string

1 Answers  


Categories