Search This Blog

Tuesday, February 1, 2011

LRM-00112: multiple values not allowed for parameter 'data'

Solution:
a. Rename the data file so that it does not have spaces in it.
b. FTP the file to a directory on your server without spaces in the directory name.
c. Run the Bank Statement Loader process again, designating the file name without spaces and the
directory on your server without spaces.
d. Confirm you no longer get the LRM-00112 error.
Since this concurrent request runs on the server, it operates with respect to the directories defined on the server. Thus, it is not possible to load a file from another location unless it is setup/mapped as a directory on your server.

Ref:Bank Statement Loader Program Errors as LRM-00112 and SQL*Loader-100 [ID 433580.1]

3 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. I have facing same issue at time of working on Auto lock process ,with the help above document. I have resolved issue

    ReplyDelete
  3. This help me. My file name was having spaces in the data file.

    ReplyDelete

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...