Database DataWarehousing (MOSC)

MOSC Banner

Materialized View Will Not Refresh

edited Jan 29, 2014 4:18AM in Database DataWarehousing (MOSC) 6 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center