This content has been marked as final. Show 3 replies
I am importing a schema from 126.96.36.199 into a 188.8.131.52 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....
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?