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_NAME DIRECTORY_PATH
---------- ------------------------- ---------------------------------------------------------------------------
SYS EXPDP_DIR F:\backup
SYS ORA_DIR e:\ora_dir
SYS SUBDIR F:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\order_entry\/2002/Sep
SYS SS_OE_XMLDIR F:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\order_entry\
SYS LOG_FILE_DIR F:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\log\
SYS DATA_FILE_DIR F:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\sales_history\
SYS XMLDIR c:\ade\aime_dadvfh0169\oracle/rdbms/xml
SYS MEDIA_DIR F:\app\Administrator\product\11.2.0\dbhome_1\demo\schema\product_media\
SYS DATA_PUMP_DIR F:\app\Administrator/admin/orcl/dpdump/
OWNER DIRECTORY_NAME DIRECTORY_PATH
---------- ------------------------- ---------------------------------------------------------------------------
SYS ORACLE_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';
目录已创建。