Materialized View does not import properly when importing a db for a second time in another schema
This is happening because it's trying to create a duplicate refresh DBMS_JOB with the ID 438.

Just re-run the failing statements manually and specify an unused job ID.

SELECT MAX(JOB)+1 FROM DBA_JOBS;


... will get you the next available ID.

(You may be able to omit the JOB=&gt; parameter and have Oracle auto-generate the ID, but I can't remember off-hand if that'll work).