RE: SQL*Loader-524: partial record found at end of datafile

From: bryan munday <bardy_at_MailAndNews.com>
Date: Thu, 12 Apr 2001 07:37:14 -0400
Message-ID: <3AE0BAD0@MailAndNews.com>

I'm not quite sure I this is the solution, but I had the same error a while ago, and the problem was a stray return character at the end of the last line,
resulting in a blank line at the end of the file. When I removed this it worked fine

>===== Original Message From hkim16_at_uic.edu (Hosung Kim) =====
>If you know about the error message, could you help me?
>
>I am trying to load a simple data by executing the command,
>d:\orant\bin>sqlldr80 scott/tiger control=reload_test.ctl log=reload.log
>but I got the following message;
>SQL*Loader-524: partial record found at end of datafile (reload_test.ctl)
>
>The content of reload_test.ctl is follwing;
>load data
>infile 'd:\plant\reload_test.csv'
>into table reload_test
>( product char terminated by ',')
>
>The content of reload_test.csv is following;
>testdata,
>
>The reload_test table has been created;
>SQL> select * from reload_test;
>PRODUCT
>------------------------------
>test
>
>
>Thank you in advance.
>
>
>Leo
>

---

 Get your FREE web-based e-mail and newsgroup access at:

                http://MailAndNews.com

 Create a new mailbox, or access your existing IMAP4 or  POP3 mailbox from anywhere with just a web browser.

---

Received on Thu Apr 12 2001 - 06:37:14 CDT