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: to - Release: 10.1 to 10.2
Oracle Solaris on SPARC (64-bit)


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


#> 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'.


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