ORA-39087: directory name is invalid

I got ” ORA-39087: directory name is invalid ”  error in Oracle database.

 

ORA-39087: directory name is invalid

 

Details of error are as follows.

[oracle@msdbadm01 ~]$ expdp mehmet/deveci DIRECTORY=datapump_dir DUMPFILE=mehmet.dmp logfile=mehmet.log schemas=mehmet

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 datapump_dir is invalid
   

 

 

directory name is invalid

This ORA-39087 error is related with the missing or invalid of  directory.

 

Make sure that the /export/dump directory has 660 permission.

 

To solve this error, create or replace your directory and grant the following priviliges to user.

create or replace directory datapump_dir as '/export/dump';
grant read,write on directory datapump_dir to mehmet;
grant datapump_exp_full_database to mehmet;
grant datapump_imp_full_database to mehmet;


 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *