Dec 04 2009

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

Published by michael 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.

Share and Enjoy:
  • Print
  • Sphinn
  • del.icio.us
  • Mixx
  • Google Bookmarks
  • Blogplay
  • Technorati
  • Twitter

Related posts:

  1. DbVisualizer auto commit problem I had some issues with DbVisualizer and auto commit. I...
  2. ls full path How do you get the Unix command ls to show...

No responses yet

Trackback URI | Comments RSS

Leave a Reply