Re: Oracle 8 SQL*Loader Bug?

The message you report almost always means the last line of the file hgm_select.dat doesn't have an end of line character (ASCII linefeed, aka newline, aka '\n'). vi puts one at the end of the file if you open a file without an end of line on the last line.

Do an ls -l (I assume you're on Unix) before and after opening and closing the file in vi and see if the file is one character bigger after.

This doesn't explain why the checksum was the same before and after.

In article <78o7ad$srk$1_at_nnrp1.dejanews.com>, 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

--

Larry Reid                             lcreid@^web.net (remove the ^)