Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Loader 524 Error: How to Prevent?
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 Tue Jul 13 1999 - 03:09:34 CDT