奇怪的impdb问题

billychen_1

大家好,今天遇到了一个奇怪的问题,是关于impdp的,


我做的操作如下:

1. 用DBA 用户登录
2. create directory TEST_DIR as '/usr/local/voyeur/herry';
3. grant read,write on directory TEST_DIR to public;
4. impdp c20700sync/c20700sync07@hzqausr DIRECTORY=TEST_DIR dumpfile=k04syc.dmp logfile=k04sync_mapping.log REMAP_SCHEMA=k04syc:c20700sync


报错如下:
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 488
ORA-29283: invalid file operation

我查了下,是说我没有给test_dir写的权限,但我第三步已经完成了,各位有什么看法?

billychen_1

我的oracle 版本是 10G

billychen_1

如果是对这个目录没有写权限,那么我去掉LOGFILE,用命令:
impdp c20700sync/c20700sync07@hzqausr DIRECTORY=TEST_DIR dumpfile=k04syc.dmp NOLOGFILE=Y REMAP_SCHEMA=k04syc:c20700sync

会报错误:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/usr/local/voyeur/herry/k04syc.dmp" for read
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

百思不得其解啊!