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

Information for Database Error Code ORA-12057: materialized view "[string]"."[string]" is INVALID and must complete refresh
Oracle® Database Error ORA-12057299/10

ORA-12057: materialized view "[string]"."[string]" is INVALID and must complete refresh

Cause: The status of the materialized view was INVALID and an attempt was made to fast refresh the materialized view.

Action: Perform a complete refresh of the materialized view. Check the value of the STATUS column in dba_mviews, all_mviews, or user_mviews to verify that the materialized view is VALID after the complete refresh.

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