Oracle impdp导入异常

SQL> select * from dba_directories;

OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS ADMIN_DIR
/database/oracle/product/10.2.0/db_1/md/admin

SYS DATA_PUMP_DIR
/database/oracle/product/10.2.0/db_1/admin/orcl/dpdump/

SYS EXPDP_DIR
/home/oracle/expdp_dir

OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS WORK_DIR
/database/oracle/product/10.2.0/db_1/work

[oracle@localhost ~]$ impdp ltkjls/a123456 directory=EXPDP_DIR dumpfile=ltkjls20140314.dmp logfile=exp_ltkjls140314.log

Import: Release 10.2.0.1.0 - Production on 星期日, 23 3月, 2014 14:31:23

Copyright (c) 2003, 2005, Oracle. All rights reserved.

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: 操作无效
ORA-39070: 无法打开日志文件。
ORA-29283: 文件操作无效
ORA-06512: 在 "SYS.UTL_FILE", line 475
ORA-29283: 文件操作无效

求组,各种方式试过无效 没有分。。。不好意思。。求同行help
Grant read,write on directory EXPDP_DIR to ltkjls;

权限有给赋予

检查一下目录:/home/oracle/expdp_dir
以及文件:ltkjls20140314.dmp 的属主
温馨提示:答案为网友推荐,仅供参考
第1个回答  2014-03-23
你对目录没有写操作的权限追问

有付权限的 Grant read,write on directory EXPDP_DIR to ltkjls;

反反复复试了N多次,导入都不成功

数据文件是从其他机器导出的