Re: SQL Loader Error---524 , Please Help

From: Brian Hummer <hummerb_at_usa.net>
Date: Mon, 26 Apr 1999 11:01:02 -0400
Message-ID: <kc%U2.2876$3F1.135601@news13.ispnews.com>

Hi Sean,

I was having this problem as well. The solution I had was to add an extra line to my .ctl file. With that added line feed, everything works well.

-Brian

zhang <zhang_at_visi.net> wrote in message news:371CD59A.6BFD_at_visi.net...
> Hello, Every one,
>
> Recently I upgraded Oracle 8.0.4 to Oracle 8i.
> Most things work out fine, but when I used the old
> Oracle 8.0.4 SQL Loader control files ( was working fine
> under Oracle 8.0.4 ), I got the following error message:
> SQL*Loader-524: Partial record found at end of datafile.
>
> I opened the datafiles , they look fine , plus they are the same
> old datafiles under 8.0.4.
>
> I am really frustrated with the Loader now, can anybody please give
> me some advices on SQL Loader? Thank you very much in advance.
>
>
> Sean Zhang
> <sean_at_cnfei.com>
Received on Mon Apr 26 1999 - 10:01:02 CDT