Dec 04 2009

SQL*Loader-522: lfiopn failed for file (loader.log)

Published by at 1:39 pm under Oracle

I used the Oracle SQL Loader to push some data into a table and got the following error: SQL*Loader-522: lfiopn failed for file (loader.log)
This somewhat cryptic error message turned out to be that Oracle SQL Loader didn’t have write permissions in the work directory i.e. in the directory where I executed the sqlldr command. Once I fixed the directory permission everything worked just fine.

8 responses so far

8 Responses to “SQL*Loader-522: lfiopn failed for file (loader.log)”

  1. Allan says:

    Thanks, great help

  2. R viswanath says:

    could you please tell me the way to fix directory permission, since i am getting the same error again and again, i dont know how to fix this error.

    • Michael says:

      When you run the SQL loader command you run this as a specific user. This user must have write permissions on the current directory, that is the directory from where you’re executing this command. You could use this command and replace with the name of the directory from where you execute the command: “chmod +w

  3. Moven says:

    Thanks very much . I had to change user security settings on the folder where sqlldr is executed from and it worked.
    Stay blessed. Good work from you.

  4. Rakesh says:

    Moven, can you provide the settings which u did?
    I has work in the same scenario, but in windows 7. I give Full Permissions to every folder and every log file.

  5. Adrian says:

    give write permission to the folder where the log will be writtten
    SQLLDR.EXE … log=c:\temp\sqldr.log

  6. raghu says:

    run cmd as an admin, it will work

Leave a Reply