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;
权限有给赋予
有付权限的 Grant read,write on directory EXPDP_DIR to ltkjls;
反反复复试了N多次,导入都不成功
数据文件是从其他机器导出的