Re: SQL*Loader

From: Henk Hultink <hhu_at_nospam.stoas.nl>
Date: Tue, 04 Apr 2000 13:43:57 +0200
Message-ID: <38E9D57D.5B64FAAA_at_nospam.stoas.nl>


Hi Marc,

Try to put an End Of Line behind the last line in your control file. We've had the same problem, but notice that the error message indicates that the real problem is in your control file (to which he - in my view wrongly - refers as datafile).

Henk Hultink
Stoas Wageningen

marc bautis wrote:

> I am trying to execute the following SQL*Loader command from a DOS
> prompt:
>
> sqlldr internal/oracle control=test.ctl log=test.log
>
> the error it gives me is SQL*Loader-524: partial record found at end of
> datafile(test.ctl)
>
> it seems as if I am using the sqlldr command wrong. Becuase i changed
> the username and password to something that didn't exist, and it gave
> me the same error.
>
> In the documentation it states that on windows you must append the
> version number to sqlldr. I have tried this, but it doesn't recognize
> anything like sqlldr81, sqlldr815, sqlldr8.
>
> My controle file seems to be ok:
>
> load data
> infile "d:/Projects/test.csv"
> replace
> into table testshit
> fields terminated by ','
> (NAME, PNUM)
>
> test.csv looks like this:
> Marc,123
> Bill,645
>
> The table does exist in oracle.
>
> Does anyone know what the problem could be?
>
> Thank you,
> Marc
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 04 2000 - 13:43:57 CEST

Original text of this message