Materialized View Will Not Refresh
We are getting the following error when we try to refresh a materialized view in our Production environment. We have checked the foreign key and as far as we can tell all are accounted for and the exact same statement works just fine in our DEV and QA instances--all underlying tables look the same accross all three instances. Can anyone tell us what can be causing this and how we can correct? thanks
SQL> exec DBMS_MVIEW.REFRESH('MV_REF_STATUS' ,METHOD => 'C');
BEGIN DBMS_MVIEW.REFRESH('MV_REF_STATUS' ,METHOD => 'C'); END;
*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
SQL> exec DBMS_MVIEW.REFRESH('MV_REF_STATUS' ,METHOD => 'C');
BEGIN DBMS_MVIEW.REFRESH('MV_REF_STATUS' ,METHOD => 'C'); END;
*
ERROR at line 1:
ORA-12008: error in materialized view refresh path
0