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

Reply via email to