LRM-00112
Saw error LRM-00112 when we tried to import data into the database by data pump.
impdp hr/hr tables=TABLE1,TABLE2 directory=DATA PUMP DIR dumpfile=import.dmp logfile=import.log
...
LRM-00112: Multiple values not allowed for parameter 'directory'
LRM-00112 means that the specified parameter of data pump does not accept multiple values, you should check the command, then try again.
Blank Space
Basically, it's blank space problem. To solve it, we correct some typos in the directory value by replacing spaces with underlines.
impdp hr/hr tables=TABLE1,TABLE2 directory=DATA_PUMP_DIR dumpfile=import.dmp logfile=import.log
It should be fine.
Equal Sign
But sometimes, the error might not be so obvious, it's induced by other parameter.
impdp hr/hr tables=TABLE1,TABLE2 directory=DATA_PUMP_DIR dumpfile=import.dmp logfile=import.log parallel 4
...
LRM-00112: multiple values not allowed for parameter 'logfile'
There's nothing wrong with the parameter LOGFILE. In fact, it's because we didn't use an equal sign after PARALLEL.
As we know, PARALLEL 4 is valid in many SQL statements to declare parallel execution, but it's invalid in data pump command.
So we correct the command by adding an equal sign after PARALLEL into this:
impdp hr/hr tables=TABLE1,TABLE2 directory=DATA_PUMP_DIR dumpfile=import.dmp logfile=import.log parallel=4
We have solved LRM-00112.