SQL*Loader-522: lfiopn failed for file

Posted on 2010-01-06
Last Modified: 2016-09-11
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 - Production on Wed Jan 6 17:23:06 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Question by:sunilbains
    LVL 15

    Accepted Solution

    Check if you have the permissions to create /tmp/test.ctl.log
    and if that filesystem is not full.

    Author Closing Comment


    Expert Comment

    by:devi lakshmi
    SQL*Loader: Release - 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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now