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
会报错误:
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