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-23301: mixed use of deferred rpc destination modes

1 Answers  


DRG-11441: gist numParagraphs string is invalid

1 Answers  


QSM-02008: non-join filter condition in WHERE or HAVING clause

1 Answers  


ORA-01542: tablespace 'string' is offline, cannot allocate space in it

1 Answers  


ORA-02090: network error: attempted callback+passthru

1 Answers  






ORA-01086: savepoint 'string' never established

1 Answers  


ORA-02854: Invalid number of request buffers

1 Answers  


ORA-26518: push queue synchronization error detected

1 Answers  


ORA-02787: Unable to allocate memory for segment list

1 Answers  


RMAN-08103: channel string: could not locate backup piece: string

1 Answers  


KUP-03015: OCI error getting datetime lfprecision.

1 Answers  


ORA-02791: Unable to open file for use with asynchronous I/O

1 Answers  


Categories