How To Resolve The Error ORA-39071 Value For EXCLUDE Is Badly Formed
Last updated on JANUARY 09, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.2 to 22.214.171.124 [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:
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
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