How To Resolve The Errors ORA-39002 ORA-39070 ORA-29283 ORA-6512 When DataPump Export Fails
(Doc ID 790163.1)
Last updated on APRIL 02, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Generic Windows
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=<directory_name> dumpfile=<dump_name>.dmp logfile=<log_name>.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-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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |