执行impdp命令出错的解决办法

来源：互联网发布：327国债事件知乎编辑：程序博客网时间：2024/05/22 16:06

问题一：

With the Partitioning, OLAP, Data Mining and Real Application Testing options

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

原因和解决办法：

create or replace directory datapumpdir as '<folder_path>';

路径有问题，重写写入

问题二：

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
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/home/oracle/Desktop/BISAMPLE/BISAMPLE.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

原因和解决办法：

impdp system/<password>@orcl directory=datapumpdir dumpfile=BISAMPLE.dmp logfile=BISAMPLE.log

dump文件名的大小写或者拼错，导致无法找到dump文件

0 0