Re: Load error

From: <marcus_chan_at_my-deja.com>
Date: Sat, 16 Oct 1999 14:43:57 GMT
Message-ID: <7ua2vc$cga$1@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 Sat Oct 16 1999 - 09:43:57 CDT