One day I was trying to run an import datapump job, and it kept failing. The error was pointing to one of the parameters being incorrect.
ORA-39005: inconsistent arguments
ORA-31600: invalid input value NULL for parameter VALUE in function DBMS_DATAPUMP.METADATA_REMAP
I opened up the parameter file to check for errors, and everything seemed ok. I couldn’t spot the error.
After a few minutes of looking and analyzing, I found something in the parameter file, that seemed like it might be the problem.
An empty space after the “:” in the REMAP_TABLESPACE clause, just as below:
REMAP_TABLESPACE=HR_INDEX:HRTEST_INDEX, HR_DATA: HRTEST_DATA
Looks like, you should not have an empty space after the “:” sign in the REMAP_TABLESPACE clause.
The above clause should look just like this:
REMAP_TABLESPACE=HR_INDEX:HRTEST_INDEX, HR_DATA:HRTEST_DATA
Once the extra space was removed, the import worked like a charm, just like it was supposed to.
The extra space after the “:” was the problem. Once I removed it, the import worked.
The same rule applies for REMAP_SCHEMA as well. If you have a space after the “:”, the import will fail with the same error.
If the space is before the “:” then the error changes to: UDI-00014: invalid value for parameter, ‘remap_schema’
The lesson here is, no empty spaces around the “:” in any of the remap clauses of the import datapump!