ORA-39088: file name cannot contain a path specification

      今天下午做了一个全库导入，脚本如下
vi impdp_full.sh
SCRIPT_DIR=/dumpdata
SAVE_DIR=/dumpdata
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=/app/oracle/product/11.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=XXXX
echo "Begin export at `date`"
impdp \'/ as sysdba\' parfile=${SAVE_DIR}/impdp_full.par LOGFILE= /dumpdata/IMP_full.log
echo  "End export  at `date`"

vi impdp_full.par 
DIRECTORY=IMP_DIR
JOB_NAME=IMP_YXFY
cluster=N
parallel=16
DUMPFILE=XXXX.dmp

遇到一个报错：
Begin export at Thu Dec 29 15:13:02 CST 2016
Import: Release 11.2.0.4.0 - Production on Thu Dec 29 15:13:02 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39088: file name cannot contain a path specification
End export  at Thu Dec 29 15:13:13 CST 2016

解决方法：
正如ORA-39088： 文件名不能包含路径说明
LOGFILE=/dumpdata/IMP_full.log 改为 LOGFILE=IMP_full.log 问题就解决了

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31404823/viewspace-2131623/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31404823/viewspace-2131623/