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

NNL-00042: LDAP bind failure: number, string

1 Answers  


CLSR-00516: No service provider found at this node

1 Answers  


PCC-00031: Invalid value given for option "string"

1 Answers  


ORA-14126: only a <parallel clause> may follow description(s) of resulting partitions

1 Answers  


ORA-16053: DB_UNIQUE_NAME string is not in the Data Guard Configuration

1 Answers  






PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables

1 Answers  


ORA-06251: NETNTT: cannot translate address file name

1 Answers  


ORA-40209: setting % is invalid for % function

1 Answers  


ORA-03249: Uniform size for auto segment space managed tablespace should have atleast string blocks

1 Answers  


QSM-02138: agg(expr) requires correspondng agg(expr*expr) function

1 Answers  


RMAN-10010: error while checking for RPC completion

1 Answers  


ORA-32739: Hang analysis aborted due to failed heap re-grow

1 Answers  


Categories