Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> sqlldr prob

sqlldr prob

From: shirish <shirish_at_rolta.com>
Date: Mon, 30 Jul 2001 19:50:56 -0700
Message-ID: <F001.00359907.20010730195021@fatcity.com>

hi
all
<SPAN

class=631464502-31072001> 
i am
facing very strange problem with sql loader
<SPAN

class=631464502-31072001> 
when
import the data(total lines=147876) into table(containing just 2 columns) at the 87754 line i am getting
error
2 errors
<SPAN

class=631464502-31072001> 
<SPAN

class=631464502-31072001>SQL*Loader-500: unable to open file name

<SPAN

class=631464502-31072001>SQL*Loader-522: lfiopn failed for file (<EM class=Italic>name)
<SPAN

class=631464502-31072001> 
i am
getting errors for the same file...
<SPAN

class=631464502-31072001> 
i have
tried other files with even more data but they all worked. the
rows parameter in sqlldr is 64 (default).
<SPAN

class=631464502-31072001> 
i have
tried to load same file with rows =2..it worked well without giving errors..
<SPAN

class=631464502-31072001> 
can u
plz point out what exactly is the probs...
<SPAN

class=631464502-31072001> 

thanks and regards !
Shirish
Khapre, <FONT color=#000080 face=Arial
size=2>SE Rolta India Ltd.Off
Ph No. (+91) (022) 8326666,8262222,8300568<FONT color=#000080 face=Arial size=2>Ext'n 2730<FONT color=#008000 face=Arial size=2>Minds are like parachutes. They only function when they are open Received on Mon Jul 30 2001 - 21:50:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US