Re: sql loader question
Date: Wed, 04 Jul 2001 06:02:17 GMT
Message-ID: <Jjy07.11261$5Z5.3500427_at_news1.elcjn1.sdca.home.com>
"Larawole" <larawole_at_aol.com> wrote in message
news:20010703171748.03581.00002363_at_ng-cf1.aol.com...
> I tried to load a flat file( comma, delimited) into an oracle db 8.1.5
> on Unix Server but got error
>
> SQL*Loader-00524 partial record found at end of datafile (string)
>
> I tried the loading the flatfile to an oracle db (personal oracle 8.0.4) on
> windows 98 and it worked.
Just a guess but when you put the flat file on the UNIX box did you convert the DOS-like CR-LFs to the LFs that UNIX likes?
Like if you vi the file, does it have a ^M at the end of every line on the screen? If so, then try converting the CR-LFs to LFs. You can do this with the freeware dos2unix.exe and unix2dos.exe utilities - search the 'net and you'll find them out there somewhere.
-Matt Received on Wed Jul 04 2001 - 08:02:17 CEST