EXPDP ORA-39083

Pdata

于 2015-04-07 10:43:47 发布

阅读量1k

点赞数

分类专栏： ORACLE 文章标签： expdp ora

本文链接：https://blog.youkuaiyun.com/Paranoimer/article/details/44917347

版权

ORACLE 专栏收录该内容

12 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;