ORA-01918: user does not exist while performing schema level import
Hi
We are performing a schema level export from our 11.2.0.4 database and trying to import it into 12.2 database
We pre created all the tablespaces on the 12.2 database
While running the Import we keep getting errors as below
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema MEPNONPROD is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'DEVDB', inst_scn=>'29177657341');COMMIT; END;
ORA-39083: Object type PROCACT_SCHEMA failed to create with error: