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-32338: on commit refresh grab all the detailed tables

1 Answers  


ORA-09961: Unable to restore termination signal handler

1 Answers  


ORA-01143: cannot disable media recovery - file string needs media recovery

1 Answers  


DRG-11601: URL store: bad syntax on request for string

1 Answers  


NNL-01045: Errors writing data stream: number

1 Answers  






ORA-25114: invalid file number specified in the DUMP DATAFILE/TEMPFILE command

1 Answers  


PCB-00200: Cannot equivalence PIC N or PIC G variable "string"

1 Answers  


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

1 Answers  


ORA-12825: explicit degree of parallelism must be specified here

1 Answers  


ORA-12700: invalid NLS parameter value (string)

1 Answers  


SQL*Loader-00602: Maximum converted length number of column string is too big for bind array

1 Answers  


ORA-38433: index "string" could not be maintained due to "string"

1 Answers  


Categories