My Oracle Support Banner

Expdp Generates ORA-39070 ORA-29283 when DIRECTORY is on DBFS (Doc ID 1350672.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
***Checked for relevance on 24-May-2013***


When attempting to expdp to an Oracle Database Filesystem (DBFS)

nohup expdp userid=\"/ as sysdba\" DIRECTORY=dumpdir DUMPFILE=expdmp_tdms_%U.dmp parfile=parfiletdms.par LOGFILE=logexp_20082011.log JOB_NAME=tdms_exp_4 &

$ cat parfiletdms.par


dumpdir is /dbfs_direct/FS1/ExpImpFolder

the following error occurs.

Export: Release - Production on Sat Aug 20 21:03:29 2011

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, Real Application Clusters, Automatic Storage Management, Oracle Label Security,OLAP, Data Mining, Oracle Database Vault and Real Application Testing
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.