使用 expdp 的 Oracle 导出给出 ORA-29283: invalid file operation 错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/34763958/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle export using expdp gives ORA-29283: invalid file operation error
提问by Andrew
I want to export my database using expdp and i am running the below command for export:
我想使用 expdp 导出我的数据库，我正在运行以下命令进行导出：
expdp SYSTEM/SYSTTEM PARFILE=export_dump.par
The export_dump.par file contains the below information:
export_dump.par 文件包含以下信息：
DIRECTORY=datapump
DUMPFILE=I.dmp
LOGFILE=I.log
SCHEMAS=RD,RC
CONTENT=ALL
I have all the permission for the directory datapump.But still when i try to run export command i am getting error as :
我拥有目录 datapump 的所有权限。但是当我尝试运行 export 命令时仍然出现以下错误：
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
回答by Shariar Imtiaz
Please check if systemhas permission on mentioned directory. If not then give permission:
请检查是否system对提到的目录有权限。如果没有，则给予许可：
GRANT READ, WRITE ON DIRECTORY datapump TO SYSTEM;
If its not fixed then please refer to below links
如果它没有修复那么请参考下面的链接
https://community.oracle.com/thread/2253168?tstart=0
http://www.dba-oracle.com/t_ora_39002_ora_39070_ora_29283.htm
https://community.oracle.com/thread/2253168?tstart=0
http://www.dba-oracle.com/t_ora_39002_ora_39070_ora_29283.htm
回答by Pero Budman
try to make the folder path inside your current desktop folder path , this 100% works for oracle 12c and windows 10.
尝试在当前桌面文件夹路径中创建文件夹路径，这 100% 适用于 oracle 12c 和 windows 10。
