Re: Load error

Hi marcus,

    What does your log file say? It should have better information. You can also specify a "bad" file, rerun your load (after truncating the table), rerun the load and then look as the bad file.

hth
jerry gitomer

marcus_chan_at_my-deja.com wrote in message <7ua2vc$cga$1_at_nnrp1.deja.com>...
>Hi Martin,
>
>I've tried to either removing and adding a blank line after the
end of
>the data file. Still having the same error. Any suggestion???
>
>marcus
>In article <3805AA7C.F7BB3962_at_totalise.co.uk>,
> Martin Hepworth <maxsec_at_totalise.co.uk> wrote:
>> marcus_chan_at_my-deja.com wrote:
>> >
>> > Hi,
>> >
>> > i'm new to Oracle. I've installed Oracle vr 8.0.5
>> > when I tried to load a delimeted file to a table I received
this
>error
>> > SQL*Loader: Release 8.0.5.0.0 - Production on Thu Oct 14
17:2:10
>1999
>> >
>> > (c) Copyright 1998 Oracle Corporation. All rights reserved.
>> >
>> > SQL*Loader-524: partial record found at end of datafile
>> > (C:/soh/test.ctl)
>> >
>> > Below is my description
>> > Control file:
>> > =============
>> > LOAD DATA
>> > INFILE 'c:\soh\admin_login.dat'
>> > INTO TABLE EBXCSLDT.ADMIN_LOGIN
>> > FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
>> > (admin_id, password, accs_right, log_key NULLIF
log_key=BLANKS)
>> >
>> > Data file
>> > =========
>> > "admin","password",0,""
>> > "admin1","password",1,""
>> > "admin2","password",2,""
>> > "admin3","password",3,""
>> >
>> > table description
>> > =================
>> > SQLWKS> describe ebxcsldt.admin_login
>> > Column Name Null? Type
>> > ------------------------------ -------- ----
>> > ADMIN_ID NOT NULL VARCHAR2(25)
>> > PASSWORD NOT NULL VARCHAR2(25)
>> > ACCS_RIGHT NOT NULL NUMBER(38)
>> > LOG_KEY VARCHAR2(40)
>> >
>> > What is wrong here?
>> > marcus
>> >
>> > Sent via Deja.com http://www.deja.com/
>> > Before you buy.
>>
>> Marcus
>> have you got a blank line at the end of the file ie..
>>
>> Data file
>> =========
>> "admin","password",0,""
>> "admin1","password",1,""
>> "admin2","password",2,""
>> "admin3","password",3,""
>>
>> ============
>>
>> Rather than
>> Data file
>> =========
>> "admin","password",0,""
>> "admin1","password",1,""
>> "admin2","password",2,""
>> "admin3","password",3,""
>> =====================
>>
>> Martin
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Oct 19 1999 - 13:10:33 CDT