Re: Sql loader 524 error

FYI -
SQL*Loader-00524 partial record found at end of datafile (string)

Cause: An incomplete record was found at the end of the indicated datafile.

Action: Make sure the last record in the datafile is complete and has the correct terminating character(s). Also, if fixed-length records are in use, verify that no record exceeds the platform-specific length for a single record.

Quoting from Kevin's post:
> > > 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

Weird characters??? Like maybe an end-of-file at about record 117,000??? Yeah, I'd say that "it that it needs to be a little cleaner" is an excellent idea!

Good luck.

plopez <plopez_at_garbage_stringuwyo.edu> wrote in message news:38E25317.19A9125E_at_garbage_stringuwyo.edu...
> I also have run into this and have not found any information either from
> Oracle (undocumented error mesg) or the news group. I *think* how I solved
> it was by adding blank lines to the end of the .ctl and/or to the end of
the
> .dat file. I am unsure as i tried many things in the process of solving
the
> problem.
>
> HTH
>
>
> kevinator_ca_at_yahoo.com wrote:
>
> > Well, for one, the data I have isn't in the control file. I did try to
> > insert a blank line at the end of the file but not many editors let you
> > open 196Mb text files. . . Any other ideas? thanks
> >
> >
>
Received on Fri Mar 31 2000 - 17:29:08 CEST