ORA-32314: REFRESH FAST of "string"."string" unsupported
after deletes/updates



ORA-32314: REFRESH FAST of "string"."string" unsupported after deletes/updates..

Answer / guest

Cause: One or more deletes or updates has been performed on
one or more of the detail tables referenced by the specified
materialized view. This materialized view does not support
fast refresh after deletes or updates.

Action: Use REFRESH COMPLETE. Note: you can determine why
your materialized view does not support fast refresh after
deletes or updates using the DBMS_MVIEW.EXPLAIN_MVIEW() API.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12989: invalid value for checkpoint interval

1 Answers  


ORA-16051: parameter string contains an invalid delay time

1 Answers  


ORA-24508: Buffer is not aligned correctly.

1 Answers  


ORA-39070: Unable to open the log file.

1 Answers   IBM,


ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

1 Answers  






ORA-12509: TNS:listener failed to redirect client to service handler

1 Answers  


ORA-26094: stream format error: input column overflow

0 Answers   HP,


NNL-01004: NOT ALLOWED responses received: number

1 Answers  


TNS-00202: Failure in redirecting call : Original to string Redirect to string

1 Answers  


KUP-01008: the bad identifier was: string

1 Answers  


ORA-08440: raw buffer is too short to hold converted data

1 Answers  


NNO-00333: warning: ROS admin_region types obsolete; using SQL

1 Answers  


Categories