My Oracle Support Banner

DataPump Export Fails with Errors ORA-39002 ORA-39070 ORA-29283 (Doc ID 2428402.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


When running a DataPump export job with the following parameters on the command line the export fails:

expdp system/manager tables=TOSPROD.TRANSFERS query=TOSPROD.TRANSFERS:"where transfer_time > to_timestamp('01/01/2017', 'MM/DD/YYYY')" directory=BACK_EXPORT_DATA dumpfile=new_data_pump.dump
Export: Release - Production on Fri Jul 20 16:04:26 2018

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

Username: system
Connected to: Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics 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 536
ORA-29283: invalid file operation




To view full details, 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 a vibrant support community of peers and Oracle experts.