7 Replies Latest reply: Apr 16, 2014 10:57 AM by tvCa-Oracle RSS

    utlu112i_8.sql : materialized views being refreshed

    tvCa-Oracle

      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 ?