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-33282: (DBERR11) Cannot wait for analytic workspace string to become available since doing so would cause a deadlock.

1 Answers  


ORA-21708: inappropriate operation on a transient object

1 Answers  


RMAN-08549: database name (or lock name space) used for search: string

1 Answers  


ORA-12229: TNS:Interchange has no more free connections

1 Answers  


ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

1 Answers  


KUP-04045: unexpected OCI status string

1 Answers  


ORA-00473: ARCH process terminated with error

1 Answers  


ORA-07209: sfofi: file size limit was exceeded.

1 Answers  


RMAN-08054: starting media recovery

1 Answers  


ORA-15021: parameter "string" is not valid in string instance

1 Answers  


DRG-10507: duplicate index name: string

1 Answers  


O2I-00122: Invalid filename for the INITFILE file

1 Answers  


Categories