Home > Database > Mysql Tutorial > expdp ORA-39070: Unable to open the log file

expdp ORA-39070: Unable to open the log file

WBOY
Release: 2016-06-07 17:34:14
Original
2627 people have browsed it

expdp ORA-39070: Unable to open the log file

Oracle中,,当执行expdp或impdp的时候,有时候会出现错误:

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

产生这个错误的原因通常有两个:

1.对存放dmp文件或log文件的路径没有权限。

2.对dmp文件没有权限。

所以,遇到这个问题,首先去检查权限。

相关阅读:

GoldenGate不使用数据泵完成Oracle-Oracle的双向复制

使用GoldenGate的数据泵进行Oracle-Oracle的单向复制

如何对 Oracle 数据泵(expdp/impdp) 进行 debug

Oracle 数据库导出数据泵(EXPDP)文件存放的位置

Oracle 10g 数据泵分区表的导出

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template