SQL*Loader-522: lfiopn failed for file

All,
There are no rows getting loaded through sqlloader.Please advise.
Below is the command.It used to run finr earlier but not working fine now.
runSqlLoader /home/work/abc.dat /home/work/test.ctl 0 0 "BINDSIZE=20000000 READSIZE=20000000 rows=200000"
/app/oracle/product/client/9.2.0/bin/sqlldr userid=123/xxxxx@db   data=/home/work/abc.dat control=/home/work/test.ctl bad=/tmp/test.ctl.bad
log=/tmp/test.ctl.log errors=0 BINDSIZE=20000000 READSIZE=20000000 rows=200000
SQL*Loader-522: lfiopn failed for file (/tmp/test.ctl.log)

SQL*Loader: Release 9.2.0.1.0 - Production on Wed Jan 6 17:23:06 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
sunilbainsAsked:
Who is Participating?
 
Franck PachotCommented:
Hi,
Check if you have the permissions to create /tmp/test.ctl.log
and if that filesystem is not full.
Regards,
Franck.
0
 
sunilbainsAuthor Commented:
Thanks
0
 
devi lakshmiCommented:
SQL*Loader: Release 10.2.0.1.0 - Production on Sun Sep 11 10:03:40 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL*Loader-522: lfiopn failed for file (emp2.log)
 
solution to this problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.