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

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms

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 10.2.0.4.0 - 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 10.2.0.4.0 - 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

Cause

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 hundreds of Community platforms