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.

One response so far

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

  1. Allan says:

    Thanks, great help

Leave a Reply