ITPub博客

首页 > 数据库 > Oracle > ORA-39088: file name cannot contain a path specification

ORA-39088: file name cannot contain a path specification

原创 Oracle 作者:随风映雪 时间:2016-12-29 18:33:29 0 删除 编辑
      今天下午做了一个全库导入,脚本如下
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博客 ” ,链接:https://blog.itpub.net/31404823/viewspace-2131623/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: seq的使用
请登录后发表评论 登录
全部评论
擅长ORACLE,pg,mysql等数据库,希望能持续分享数据库相关的知识,以及一些平常工作中遇到的问题

注册时间:2016-10-23

  • 博文量
    22
  • 访问量
    38671