Skip to content

How to Resolve UDI-00014: invalid value for parameter

  • by

UDI-00014

Saw error UDI-00014 when using impdp to import some tables.

[oracle@test ~]$ impdp system/password@orclpdb tables=hr.employees remap_table=hr.employees,emp_bak dumpfile=expdp-full.dmp
...
UDI-00014: invalid value for parameter, 'remap_table'

UDI-00014 means that the value is not acceptable for the specified parameter, you have to fix the value in order to proceed the import.

In this case, the correct format of REMAP_TABLE should be:

REMAP_TABLE=schema_name.old_table_name:new_table_name

Solution

We should use the correct format to set the value of the parameter. In this case, we should use a semicolon (:) instead of a comma to separate the old and new table name.

[oracle@test ~]$ impdp system/password@orclpdb tables=hr.employees remap_table=hr.employees:emp_bak dumpfile=expdp-full.dmp

Leave a Reply

Your email address will not be published. Required fields are marked *