Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sqlm loader error 524

sqlm loader error 524

From: <susil99_at_my-deja.com>
Date: Wed, 08 Dec 1999 22:00:35 GMT
Message-ID: <82mke0$rv4$1@nnrp1.deja.com>


Hello all
I am getting this error as I run the sql loader

SQL*Loader-524: partial record found at end of datafile (test.ctl)

the run command is
>sqlldr80 userid=test/test45_at_crm1 control=test.ctl log=log.log

control file look like:

LOAD DATA
INFILE 'TEST.DAT'
INTO TABLE TEST
(
NAME POSITION(01:3) CHAR
)

Data file looks like:

tim
scott
jim

so what am i doing wrong here?
Please advise me.

SR

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 16:00:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US