My Oracle Support Banner

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

Last updated on AUGUST 02, 2019

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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 Backup Service - Version N/A 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/<password> tables=<OWNER>.<TABLE NAME> query=<OWNER>.<TABLE NAME>:"where <COLUMN 1>> to_timestamp('01/01/2017', 'MM/DD/YYYY')" directory=<DIRECTORY NAME> 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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.