Re: Oracle 8 SQL*Loader Bug?

Hi,

I would try generating the checksum using 'sum -r', you might find the files do actually have different checksums. Even quicker perform a 'tail -1 /data01/data/hgm_select.dat | od -h' to obtain a hex dump on the last line in your datafile.

Chris.

eldata_at_msn.com wrote:
>
> We are in the progress of migrating several of our instances at work from
> Oracle 7.2.3 to 8.0.5 and have stumbled upon a somewhat strange problem with
> the Oracle 8 SQL loader. We are getting the following error only in Oracle 8;
>
> SQL*Loader-524: partial record found at end of datafile
> (/data01/data/hgm_select.dat)
>
> If the file hgm_select.dat is then opened in vi and saved without making any
> changes the load operation succeeds without error. When we do a diff between
> the data file before and after there is no difference. When we do a checksum
> comparison there is no difference. As far as can be seen only the file's
> date/time information changes. Does anyone have a clue as to what could be
> going on. The gurus at work are stumped and all point to a bug in Oracle 8.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Jan 27 1999 - 17:55:45 CST