Sujeet APPS DBA: ORA-39087: directory name DPUMP

This error may be returned if you are trying to export or import using oracle data pump,

but invalid directory name has been provided during this process.

Following is an example of this.

Error:

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

Export: Release 11.2.0.3.0 - Production on Wed Aug 2022 10:07:55

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:

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

SQL> CREATE OR REPLACE DIRECTORY DPUMP_DIR AS '/u01/dpump'

NOTE :

If SYS or SYSTEM user will be used for export/import, granting rights on above directory are not needed,

otherwise grant rights to the user performing export/import

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

Now try to take export again. It should work.

Sujeet APPS DBA