Re: Sql loader 524 error

[Quoted] [Quoted] Well, for one, the data I have isn't in the control file. I did try to [Quoted] insert a blank line at the end of the file but not many editors let you open 196Mb text files. . . Any other ideas? thanks

kevin

In article <38E1908B.7B336DBB_at_lazerlink.com>, "Scott A. Haas" <sahaas_at_lazerlink.com> wrote:
> Take a peek at a previous message in this newsgroup ....
>
> SQL Loader Error posted by sboucher_at_my-deja.com Mon 9:01 AM
> and
> RE: SQL Loader Error posted by Mike Morgan Mon 11:43 AM
>
> kevinator_ca_at_yahoo.com wrote:
> >
> > Hello,
> > I'm trying to load a file that has 620,000 records with SQL*Loader.
I
> > have Oracle 8.1.5. The file is about 196 MB. I start sql loader and
it
> > quits at like 117,000th record or so with an error 'SQL*Loader-524:
> > partial record found at end of datafile (filetoload.csv)'. I was
> > wondering if anyone knew what might raised this error. The Oracle
> > documentation isn't real helpful. The error message isn't even in my
> > Oracle8 Error messages book!
> > I usually use a direct load because it goes much faster but I tried
> > both direct and indirect (if you call it that) and get the same
result.
> > I wonder if it's the size of the file or if I just need to tell the
> > people that are sending it that it needs to be a little cleaner
because
> > there are some weird characters in it or maybe it's something wrong
> > with Oracle . . . .Any thoughts? Thanks for the help
> >
> > kevin
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 29 2000 - 19:25:05 CEST