SQL*Loader

From: marc bautis <bautisma_at_earthlink.net>
Date: Mon, 03 Apr 2000 19:26:57 GMT
Message-ID: <8car9d$mbo$1_at_nnrp1.deja.com>



[Quoted] 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 Mon Apr 03 2000 - 21:26:57 CEST

Original text of this message