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-06421: NETCMN: Error detected in the read-in data

1 Answers  


ORA-31606: XML context number does not match any previously allocated context

1 Answers  


ORA-00382: %s not a valid block size, valid range [string..string]

1 Answers  


RMAN-06577: FROM TAG option may only be used with datafilecopies

1 Answers  


ORA-36770: (XSPGERRPERMDETACH) Parallel updating analytic workspace string failed

1 Answers  






RMAN-06485: changed archivelog expired

1 Answers  


ORA-25951: join index where clause cannot contain OR condition

1 Answers  


ORA-02057: 2PC: string: bad two-phase recovery state number string from string

1 Answers  


ORA-26019: Column string in table string of type string not supported by direct path

1 Answers  


ORA-30493: The percentile value should be a number between 0 and 1.

1 Answers  


ORA-02237: invalid file size

1 Answers  


TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.

1 Answers  


Categories