Basically I have a problem with materialized views that have an invalid status because I am afraid that it will interfere with the upgrade I wish to do from 11.2.0.1 to 11.2.0.4. Otherwise I wouldn't care because the
views seem to work. (My fear is regarding utlu112i.sql as referenced in 1276368.1) Anyway I had 2 materialized views that insist on being invalid despite getting refreshed via dbms_mview.refresh('myview','C'); Then I got the bright idea to check
dba_dependenices. One view was dependent on 2 other views and 2 functions. The other was dependent on 2 functions and one view. I got the unfortunately very bad idea
to recompile those dependent objects, which I did. Then I found that not only were the original 2 materialized views still invalid but also 2 more were invalid that
were not before. Golly! I blew that. Any ideas about how to deal with this (4 invalid materialized views)? BTW the ddl dates were all years ago like 2013 and 2015. I am not finding
a lot of info about how to tell why the database doesn't like these views.