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;
Oracle导入错误解决
本文介绍了一个关于Oracle数据库导入过程中遇到的ORA-31625和ORA-01435错误,该错误通常是因为导出文件中所引用的用户不存在或者没有赋予足够的权限导致的。文章提供了解决方案,包括使用sysdba连接并授予exp_full_database权限。
1836

被折叠的 条评论
为什么被折叠?



