7 Replies Latest reply on Mar 7, 2013 4:56 AM by Hussein Sawwan-Oracle

    Error on compile the Materialized view refresh

    Muthu
      Hello all,

      I am getting issue while compile the Materialized view refresh.

      ALTER MATERIALIZED VIEW FII_GL_AGRT_SUM_MV COMPILE;--( did successfully)

      exec DBMS_MVIEW.REFRESH('APPS.FII_GL_AGRT_SUM_MV','C');

      Error:

      ORA-12008: error in materialized view refresh path
      ORA-01013: user requested cancel of current operation
      ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2545
      ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2751
      ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2720
      ORA-06512: at line 1

      Please tell me what could be the issue

      Thanks and Regards,
      Muthu