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?
The note involves shutting down the database and changing the Instance service to run as the OS account. I do not want to do this and was wondering if there was another way short of shutting down the database.