Re: sql loader question
From: Tweetie Pooh <tp601553_at_cia.gov>
Date: Sun, 22 Jul 2001 06:56:09 GMT
Message-ID: <Xns90D4761739454TweetiePooh_at_62.253.162.105>
>
> 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
>
>
>
Date: Sun, 22 Jul 2001 06:56:09 GMT
Message-ID: <Xns90D4761739454TweetiePooh_at_62.253.162.105>
"Matt B." <gtimatt_at_home.com> honoured comp.databases.oracle.tools on Wed 04
Jul 2001 07:02:17a with
news: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
>
>
>
or open file in vi then
:%s/<CTRL-V>M//
:wq
Received on Sun Jul 22 2001 - 08:56:09 CEST