Oracle DB Error ORA-12057 materialized view "string"."string" is INVALID and must complete refresh

Oracle DB Error ORA-12057 materialized view "string"."string" is INVALID and must complete refresh

The following is the cause of this error:

The status of the materialized view was INVALID and an attempt was made to fast refresh the materialized view.

Action you can take to resolve this issue: 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.


Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution