Re: SQL Loader 524 Error: How to Prevent?

[Quoted] [Quoted] Don't worry its not a problem. All the good records will be loaded and the [Quoted] [Quoted] dodgy ones rejected. You can verify this by checking the log file which will [Quoted] be generated in the same directory as the control file by default.

[Quoted] You can set SQL*Loader up to keep loading until a certain number of errors [Quoted] occur ( I think this is 50 by default). If you only have one or two dodgy [Quoted] records at the end of the file you will not hit this limit. Even if you did [Quoted] you could increase the limit.

[Quoted] Everything is detailed quite well in the manual.

IIFThen wrote:

> 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 Mon Jul 12 1999 - 22:01:05 CEST