Link to home
Start Free TrialLog in
Avatar of sunilbains
sunilbains

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Franck Pachot
Franck Pachot
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sunilbains
sunilbains

ASKER

Thanks
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