How to resolve UDI-00014: invalid value for parameter, 'transform' errors with Datapump Import
Last updated on APRIL 29, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
This note helps you in resolving UDI-00014: invalid value for parameter, 'transform' errors when using DataPump Import's query based import.
The import log can report the following errors:
$ impdp test/vk directory=mydir dumpfile=vk.dmp transform=table_compression_clause:"COMPRESS BASIC" remap_schema=scott:testing
Import: Release 18.104.22.168.0 - Production on Wed Aug 28 10:03:53 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
UDI-00014: invalid value for parameter, 'transform'
The impdp transform clause on 12c does not seem to be working correctly. This version of the clause works:
$ impdp test/vk directory=mydir dumpfile=vk.dmp transform=table_compression_clause:"compress" remap_schema=scott:testing
which would default to compress basic. However, this does not work:
$ impdp test/vk directory=mydir dumpfile=vk.dmp transform=table_compression_clause:"compress basic" remap_schema=scott:testing
The documentation seems to infer that compress basic would be the correct clause (and compress advanced) as seen here (from 12c utilities guide):
TABLE_COMPRESSION_CLAUSE:[NONE | compression_clause]
If NONE is specified, the table compression clause is omitted (and the table gets the default compression for the tablespace). Otherwise the value is a valid table compression clause (for example, NOCOMPRESS, COMPRESS BASIC, and so on). Tables are created with the specified compression. See Oracle Database SQL Language Reference for information about valid table compression syntax.
If the table compression clause is more than one word, it must be contained in single or double quotation marks.
Specifying this transform changes the type of compression for all tables in the job, including tables that provide storage for materialized views.
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