Let’s have look on today’s post which is about the error that occurs during the export and import the data.
Let’s have look to resolve the issue with the following steps.
Take export at the schema level
[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_1/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;
Thought of the Day!
“Life’s a journey. It’s a journey about discovering limits.” – Larry Ellison
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
