ORA-39002 ORA-39070 ORA-29283 ORA-06512 ORA-29283 Errors When Excute Expdp

Today I have been reported with the next error;

Export: Release – Production on Thu Feb 23 10:19:00 2017

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release – 64bit Production
With the Partitioning, OLAP and Data Mining options
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

The problem is simple and the solution very easy. There isn’t a directory created in the database. The next command create a Oracle database directory where dump the data and logs for expdp. If you can some directories whit data pump “directory” parameter you can choose which you want.

create directory dumps_and_logs as ‘/server/prod/dbhome_1/scracth’;






Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s