ORA-32332: Resolution

ORA-32332: Resolution

ERROR at line 1:

ORA-32332: cannot refresh materialized view "Materialized View Name"

as type evolution has occured

Resolution:

1)      Check if the materialized view is valid .

SELECT * from dba_objects where object_name =<view_name>

2)      Check if underneath compoennts are valid

3)      If Underneath all tables are there, check if any field has been added to the same.

If yes, get a complete refresh for materialized view.

In my case, one of the underneath view was invalid.