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; |