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



ORA-12057: materialized view "string"."string" is INVALID and must complete ref..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31694: master table string failed to load/unload

1 Answers  


ORA-10640: Operation not permitted during SYSTEM tablespace migration

1 Answers  


ORA-25016: cannot specify column list for insert into nested table view column

1 Answers  


ORA-29538: Java not installed

1 Answers  


ORA-06256: NETNTT: remote fork failed

1 Answers  






ORA-02438: Column check constraint cannot reference other columns

1 Answers  


ORA-14405: partitioned index contains partitions in a different tablespace

1 Answers  


ORA-25281: complete reciever information not provided to non-repudiate reciever

1 Answers  


QSM-01048: join back level(s) not present (string)

1 Answers  


ORA-16729: Validating the value of property string hits error string.

1 Answers  


ORA-04077: WHEN clause cannot be used with table level triggers

1 Answers  


ORA-31415: change set string does not exist

1 Answers  


Categories