Re: import flat file

SQLLoader is the best way to import data as far as I'm concerned. I've had no trouble with speed, would you like me to send you a sample control file?

Are you using fixed or variable length fields in your flat file? Are you actually receiving errors, or does it just appear to hang?

E-Mail me at lesley_at_vimich.com if you want help with control files - or send me your control file and I can have a look at it. Lesley.

"RMG" <rm.giebels_at_wanadoo.nl> wrote in message news:3a5895b4$0$22379_at_reader5...
> Hi
>
> Im trying to import a flat file (about 39.000 records) into an Oracle
> database. I tried to use SQL*LOADER, but it only seems to work when I try
 a
> smaler file.
>
> Can anyone tell me if it just takes that long to import the file or that I
> have to do something special to do this..... Or maybe tell me if there is
> some other tool to do this and see what is happening.......
>
> Thx
>
> SyKo
> rm.giebels_at_wanadoo.nl
>
>
>
Received on Mon Jan 08 2001 - 17:37:48 CET