Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Loader 524 Error: How to Prevent?
Don't worry its not a problem. All the good records will be loaded and the
dodgy ones rejected. You can verify this by checking the log file which will
be generated in the same directory as the control file by default.
You can set SQL*Loader up to keep loading until a certain number of errors occur ( I think this is 50 by default). If you only have one or two dodgy records at the end of the file you will not hit this limit. Even if you did you could increase the limit.
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 - 15:01:05 CDT