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!

Changing Datapump Directory

1006995May 15 2013 — edited May 16 2013

Hello

Because of space issues on the C drive, I am attempting to change the current data pump dir from c:\x\y\z\dpdump to g:\x\y\z\dpdump.

OS ENV = windows 2003
Database = 10gR2

These are the steps I have taken:

CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR AS 'G:\x\y\z\dpdump'
GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO dpuser

SELECT directory_name, directory_path FROM dba_directories

DIRECTORY_NAME DIRECTORY_PATH
-------------------------- -----------------------------
DATA_PUMP_DIR G:\x\y\z\dpdump

expdp xyz/xyz@xyz full=Y directory=DATA_PUMP_DIR dumpfile=xyz.dmp logfile=xyz.log

Export: Release 10.2.0.3.0 - Production on Wednesday, 15 May, 2013 17:48:03

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Produc
tion
With the OLAP and Data Mining options
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

If I change the datapump directory back to c: then it works, but I have to kill to job because of the space limit issue.