Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-12004: REFRESH FAST cannot be used for materialized view "[string]"."[string]"
Oracle® Database Error ORA-12004251/10

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

Action: 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.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle