ORA-39002

oracle 11g执行expdp导出脚本时报错：

ORA-39002:操作无效
ORA39070:无法打开日志文件
ORA-29283:文件操作无效
ORA-06512:在“SYS.UTL_FILE”,line 536
ORA-29283:文件操作无效

解决方式：
这是由于导出的目录不存在，需要新建directory相关目录
新建expdp导入导出目录
SQL> col owner for a10
SQL> col directory_name for a25
SQL> col DIRECTORY_PATH for a80
SQL> select * from dba_directories;

OWNER DIRECTORY_NAMEDIRECTORY_PATH
———- ————————- —————————————————————————
SYSEXPDP_DIR F:\backup
SYSORA_DIRe:\ora_dir
SYSSUBDIRF:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\order_entry\/2002/Sep
SYSSS_OE_XMLDIR F:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\order_entry\
SYSLOG_FILE_DIR F:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\log\
SYSDATA_FILE_DIR F:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\sales_history\
SYSXMLDIRc:\ade\aime_dadvfh0169\oracle/rdbms/xml
SYSMEDIA_DIR F:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\product_media\
SYSDATA_PUMP_DIR F:\app\Administrator/admin/orcl/dpdump/

OWNER DIRECTORY_NAMEDIRECTORY_PATH
———- ————————- —————————————————————————
SYSORACLE_OCM_CONFIG_DIR F:\app\Administrator\product\11.2.0\dbhome_1/ccr/state

已选择10行。

其中EXPDP_DIR对应的目录就是expdp导入导出的路径

修改EXPDP_DIR
SQL> create or replace directory EXPDP_DIR as ‘E:\backup’;
目录已创建。