Shirish,

Check the alert.log. Most likely there is an
ORA-7445, ORA-600 or some other error around the time
when the error occurred.

A bit misleading since an ORA-3113 would be the more
common error when connectivity is lost with the
server. I suspect that the error is causing the file
handle to be closed/lost/mangled, but the process
still exists.

HTH,

-- Anita

--- shirish <[Email Address Removed] wrote:
> hi all
>
> i am facing very strange problem with sql loader
>
> when import the data(total lines=147876) into
> table(containing just 2 columns) at the 87754 line
> i am getting
> error 2 errors
>
> SQL*Loader-500: unable to open file name
> SQL*Loader-522: lfiopn failed for file (name)
>
> i am getting errors for the same file...
>
> i have tried other files with even more data but
> they all worked.
> the rows parameter in sqlldr is 64 (default).
>
> i have tried to load same file with rows =2..it
> worked well without giving errors..
>
> can u plz point out what exactly is the probs...
>
> thanks and regards !
> Shirish Khapre, SE Rolta India Ltd.
> Off Ph No. (+91) (022) 8326666,8262222,8300568
> Ext'n 2730
> Minds are like parachutes. They only function when
> they are open
>
>


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
Oracle LazyDBA home page