3 Replies Latest reply: Jul 17, 2014 3:43 AM by Richard Harrison . RSS

    ORA-39083: Object type MATERIALIZED_VIEW failed to create with error

    aparm

      Hi there

      I am importing a schema from 11.1.0.7 into a 11.2.0.4 database using impdp and I found the following error in the log file

       

      ORA-39083: Object type MATERIALIZED_VIEW failed to create with error:

      ORA-00942: table or view does not exist

      ORA-04063: view "CONS.V_ATTENDANCE" has errors
      Failing sql is:
      CREATE MATERIALIZED VIEW CONS.MV_ATT01....

      SELECT

      ..

      FROM CONS.V_ATTENDANCE

       

      My question is, why does it fail to create the materialized view, it has managed to CONS.V_ATTENDANCE with errors, it is possible to force it to create the materialized view even with errors?

       

      Thanks