ORA-39087: directory name DPUMP_DIR is invalid

Problem:

[oracle@hostname ~]$ expdp scott/tiger DIRECTORY=dpump_dir DUMPFILE=scott.dmp logfile=scott.log schemas=scott

Export: Release 11.2.0.3.0 - Production on Wed Dec 18 10:07:55 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

ORA-39002: invalid operation

ORA-39070: Unable to open the log file.

ORA-39087: directory name DPUMP_DIR is invalid

 

Solution:

Check the directory is exists or not, If not exist then create the directory with proper path: 

CREATE OR REPLACE DIRECTORY DPUMP_DIR AS '/holding/dpump'

  

If the directory exists then check grant on the directory, if the grant missing then provide grant 

SQL> GRANT READ, WRITE ON DIRECTORY DPUMP_DIR TO SCOTT;

Comments