You are here: Home // Oracle 11g // ORA-12004: REFRESH FAST cannot be used for materialized view “string”.”string”

ORA-12004: REFRESH FAST cannot be used for materialized view “string”.”string”

Cause: The materialized view log does not exist or cannot be used. PCT refresh is also not enabled on the materialized view See the solution below.

Error solution: Use just REFRESH, which will reinstantiate the entire table. If a materialized view log exists and the form of the materialized view allows the use of a materialized view log or PCT refresh is possible after a given set of changes, REFRESH FAST will be available starting the next time the materialized view is refreshed.

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: nagrobki dhl katowice Stanisław Swoboda energetyka wiatrowa Garnki Fissler