in Oracle
SQL*Loader-522: lfiopn failed for file (loader.log)
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.
Comments
9 Comments
Thanks, great help
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.
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 “
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.
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.
give write permission to the folder where the log will be writtten
SQLLDR.EXE … log=c:\temp\sqldr.log
Sir, how to give write permission to the folder
run cmd as an admin, it will work
please just right click on folder and go to security and permission click
Leave a Comment