Oracle - Import datapump errors

最新推荐文章于 2024-07-30 08:30:00 发布

原创最新推荐文章于 2024-07-30 08:30:00 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ORA-39002 #ORA-39070 #ORA-39087 #ORA-29283 #datapump

本文解决了在使用Oracle数据泵进行数据库导入时遇到的ORA-39002、ORA-39070等错误。通过创建目录、授予用户读写权限及确保Linux环境下文件夹权限正确设置的方法，成功解决了这些问题。

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

I got below errors when I was doing datapump import for oracle database today.

impdp 'xeuser/password@xe' directory=datadump schemas=xeuser dumpfile=BACKUP.DMP logfile=impdp.log

...

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DATADUMP is invalid

How to resolve?

1. create directory

SQL>create or replace directory datadump as '/dumpdir';

I named this direcotry as datadump. You can name it as what you want.

2. grant read, write permission to user

SQL>grant read,write on directory datadump to xeuser,sys;

3. please notice: if you use linux os you need to do one more thing:

Make sure oracle has the write permission of datadump folder and has the read permission of your datadump file.

Ortherwise you more likely get error below:

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation

Don't repeat my mistake!

I just simply gave rwx for all users.