DataPump Export (EXPDP) Fails With Error UDE-14 When Exporting Partitions Begining With Numbers

(Doc ID 603930.1)

Last updated on NOVEMBER 17, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2
Oracle Solaris on SPARC (64-bit)

Symptoms

When trying to use DataPump to export partitions beginning with numbers you encounter the error UDE-14.

When exporting as follows:

#> expdp test/test tables="RANGE_SALES2":"1998_sales","RANGE_SALES2":"2008_sales" dumpfile=test.dmp logfile=test.log

or:

#> expdp test/test tables="RANGE_SALES2:1998_sales","RANGE_SALES2:2008_sales" dumpfile=test.dmp logfile=test.log

results in:

UDE-00014: invalid value for parameter, 'tables'.

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