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.ct l 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.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL*Loader-522: lfiopn failed for file (emp2.log)
solution to this problem
ASKER