Re: SQL Loader 524 Error: How to Prevent?
Date: Tue, 13 Jul 1999 09:09:34 +0100
Message-ID: <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 ...
>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 Tue Jul 13 1999 - 10:09:34 CEST