How To Resolve The Errors ORA-39002 ORA-39070 ORA-29283 ORA-6512 When DataPump Export Fails

(Doc ID 790163.1)

Last updated on OCTOBER 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Generic Windows
***Checked for relevance on 04-Oct-2017***

Goal

This note helps you to resolve ORA-39002 ORA-39070 ORA-29283 ORA-6512 Errors and completing DataPump Export jobs.

1. The Data Pump Export can fail with the following errors:

#> expdp system/password directory=exportdp dumpfile=expdp_test.dmp logfile=expdp_test.log

Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 05 March, 2009 10:43:55

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production with the
Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing 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 488
ORA-29283: invalid file operation


2. DataPump export fails with same errors even after dropping and re-creating the DataPump utility and re-creating the directory.

Can report the following errors when attempt to run a datapump export

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 488
ORA-29283: invalid file operation

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms