Re: Any Ideas on this SQL*Loader Puzzle

From: Stefan Martin <S.Martin_at_DeutschePost.de>
Date: Wed, 14 Jul 1999 12:54:11 +0200
Message-ID: <7mhq7o$13220_at_ppd00021.deutschepost.de>


has it been send as an ASCII-File
IIFThen schrieb in Nachricht ...
>
>From: IIFThen <msessions_at_aldensys.com>
>Subject: Re: SQL Loader 524 Error: How to Prevent?
>Date: Tuesday, July 13, 1999 7:55 AM
>
>Well...SQL*Loader says all records loaded correctly but when I query the
>table for these records it returns a count of 0. Try putting an eof
>character or any character at the end of your data file(i'm using an
>external one) and see if you can generate a nonzero count when you query
the
>Oracle table. I'd like to know if I'm doing something crazy. FYI:
SQL*Loader
>seems to handle partial records anywhere but the last line of the file.
>
>BTW: The data file that I'm loading is being ftp'ed over to a server and
I'm
>automatically running the SQL*Loader program against it. Therefore, I need
>for SQL*Loader to reject all partial records especially on the last line
>which I suspect is preventing my records from "actually" being loaded.
>
>Thanks!
>
>IIFThen
>
>Mark G <someone_at_hot> wrote in message news:378af1e8.0_at_145.227.194.253...
>> I had this a few times.
>> The problem is with the end of file so all records before that should be
>> loaded ok (well, it loaded all for me).
>> I once was told that make sure a carriage return is at the end of your
>file
>> so sql*loader knows what the last record is. Also a carriage return at
>the
>> end of your control file.
>>
>> Try it and see.
>>
>> M
>>
>> IIFThen wrote in message ...
>> >Hello. I'm loading Oracle 8 db with variable length records. How can I
>> >prevent the following error from happening if the
datafile(aithwsub.data)
>> >has junk on a record like eof character, etc:
>> >
>> >SQL*Loader-524: Partial record found at end of datafile (aithwsub.dat)
>> >
>> >Is this even a problem? Will the good records be loaded and the bad ones
>> >discarded? I looked through the SQL reference manual and nothing jumped
>out
>> >at me as an obvious solution.
>> >
>> >Thanks!
>> >
>> >Michael
>> >
>> >
>>
>>
>
>
>
>
Received on Wed Jul 14 1999 - 12:54:11 CEST

Original text of this message