7 Replies Latest reply on Apr 16, 2014 3:57 PM by tvCa-Oracle

    utlu112i_8.sql : materialized views being refreshed


      Document 884522.1 says to run script utlu112i_8.sql on my version 11gR1 Vision 12.1 database, to prepare for 11gR2 upgrade

      The report says there are Materialized Views in refresh progress


      I was checking document 1526264.1 which says how to check if such action is busy, and with all details ... but, all of the SELECT statements return : no rows selected.

      And, afterwards, when I run utlu112i_8.sql again, it says : Materialized Views are in refresh progress


      What's wrong here ?


      Apart from the fact the report itself doesn't state much hint how to fix the issue, how do you fix the issue ? Is the report correct ?