Load error

From: <marcus_chan_at_my-deja.com>
Date: Thu, 14 Oct 1999 09:54:44 GMT
Message-ID: <7u4991$a8q$1@nnrp1.deja.com>

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. Received on Thu Oct 14 1999 - 04:54:44 CDT