oracle11g expdp报错 ORA-06512: at "SYS.UTL_FILE", line 536

今天在使用expdp导出的时候报如下错误

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

查找问题发现是指定文件夹有问题，解决办法
查看文件夹

select * from dba_directories;

发现文件地址指定有问题，重建文件并授权问题解决。

create or replace directory  DPUMPDIR as  '/home/oracle/oradmp' ;
grant read ,write on directory  DPUMPDIR  to PROD_ADB;

专业墙纸贴纸厨房用具装饰出售，本人网店经营

博客对你有用记得访问下哦，增加下访问量，如有需要可以下单购买哦^_^。https://item.taobao.com/item.htm?id=569617707364