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-29895: duplicate base datatype specified

1 Answers  


ORA-26711: remote table does not contain a primary key constraint

1 Answers  


PCB-00630: Host variable is not of LOB type

1 Answers  


ORA-25183: index-organized table top index segment is in a different tablespace

1 Answers  


TNS-01013: set|show trc_{ } [<value>]: set|show trace parameters of current listener

1 Answers  


ORA-38470: cannot revoke a privilege that was not granted.

1 Answers  


ORA-24391: invalid fetch operation

1 Answers  


ORA-01684: max # extents (string) reached in table string.string partition string

1 Answers  


ORA-24408: could not generate unique server group name

1 Answers  


NNL-01056: Requests forwarded: number

1 Answers  


ORA-09871: TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.

1 Answers  


DRG-11710: thesaurus term string too long

1 Answers  


Categories