if you receive the following error message:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning option
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 536
ORA-29283: invalid file operation
**** Resolution:
Create a database directory that has been grante privilege access to the user who is performing “expdp” operation.
SQL> create or replace directory DB_EXPORT as ‘/oracle/export/db/;
Directory created.
SQL> grant read, write on directory DB_EXPORT to expdp_user;
Grant succeeded.
Where expdp_user could be ‘system’ user, or any user that has ‘DBA’ role privilege.
Example of expdp command:
expdp expdp_user /XXXX directory=DB_EXPORT logfile=db_test.log dumpfile=EXDP_TEST.dmp schemas=HR
