Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Pump - Trying to Export to Another Server Gives Error

632013Dec 23 2008 — edited Dec 26 2008

hi experts,

I'm using 10.2.0.4 on Windows.

I want to create a Scheduler job to periodically refresh my test database from my production database which resides on a different Windows server.

Using the Database Control GUI to create the Export job, if I specify a Directory that is on the other server, the job fails to create and I get this error:

Export Submit Failed

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 488 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 2953 ORA-06512: at "SYS.DBMS_DATAPUMP", line 3189 ORA-06512: at line 2

But if I use a local directory ie one that is on the same server that the export will run on.... no problem - job is created and it executes fine.

?? What is required to be able to export to a non-local destination?

Thanks, John

Database Software

Data Pump - Trying to Export to *Another Server* Gives Error

Data Pump - Trying to Export to Another Server Gives Error