My Oracle Support Banner

How To Resolve The Error ORA-39071 Value For EXCLUDE Is Badly Formed (Doc ID 734324.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.
*** Checked for relevance on 09-Jan-2017 ***


While performing the DataPump in an UNIX or Linux environment you may get the following error, if EXCLUDE or INCLUDE parameter is specified in command prompt:

#> expdp scott/tiger dumpfile=test.dmp exclude=table:"='DEPT'" directory=scott


Export: Release - Production on Wednesday, 27 August, 2008 5:28:46

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

Connected to: Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
and Real Application Testing options
ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00904: "DEPT": invalid identifier


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.