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-27159: failure setting process scheduling priority

1 Answers  


ORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.

1 Answers  


SQL*Loader-00401: End field position number must be greater than or equal to start number

1 Answers  


RMAN-08066: database reset to incarnation string

1 Answers  


SQL*Loader-00268: UNRECOVERABLE keyword may be used only in direct path.

1 Answers  






ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

1 Answers  


RMAN-06011: invalid level specified: number

1 Answers  


ORA-01325: archive log mode must be enabled to build into the logstream

1 Answers  


ORA-26502: error resignal

1 Answers  


ORA-07509: scgfal: $deq parent lock unexpected return

1 Answers  


ORA-13521: Unregister operation on local Database id (string) not allowed

1 Answers  


ORA-00341: log string of thread string, wrong log # string in header

1 Answers  


Categories