ORA-0942 DWADMIN.REFRESH_MAT_VIEW

Hi All,

We see the following error message very often and informatica fails due to this error

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430

ORA-06512: at "ADMIN.REFRESH_MATE_VIEW", line 5

ORA-06512: at line 2

As per 1087507.1, i see the note 867042.1 says that  "The table on which the master mview was based was changed to a table with a different definition"

When i report this to DEV team (informatica), they disagree that there was no changes made on definition. This always being confusion between DBA & DEV team and always i see this error and everytime, we need to recompile the MVs.