Google Search

Showing posts with label ORA-32332: Resolution. Show all posts
Showing posts with label ORA-32332: Resolution. Show all posts

Wednesday, June 3, 2015

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.