Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "NC50"."SYS_IMPORT_SCHEMA_04" successfully loaded/unloaded
Starting "NC50"."SYS_IMPORT_SCHEMA_04": nc50/******** directory=MYPUMP dumpfile=wzoh1012.dmp schemas=wzoh content=all
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: Schema WZOH is needed to import this object, but is unaccessible
ORA-01435: user does not exist
Failing sql is:
when this errors occurs, means that your didn’t assign EXP_FULL_DATABASE to the use which you exported dmp file,so when you import the dmp, this error occurs.
conn / as sysdba;
grant exp_full_database to NC50;