Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Load error
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 Received on Thu Oct 14 1999 - 05:03:40 CDT