Datapump - using a mapped network drive
I tried to initiate a datapump export from a 10g database but I would like the export dump to be copied via a mapped network drive to another server.
These are the steps I used:
1. I created a directory object on the source database :
create directory DP_TEST_DIR AS '\\uknbumed02\T$\dp_pump_test';
2. grant, read ON DIRECTORY DP_TEST_DIR to system;
3. I run the export using the EM console
I get this error:
Errors: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 475 ORA-29283: invalid file operation Exception : ORA-39002: invalid operation ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 2926 ORA-06512: at "SYS.DBMS_DATAPUMP", line 3162 ORA-06512: at line 2
There is a metalink note 428130.1 which suggests changING the Oracle service to run as this account. Is there another workaround for this problem?