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

Home -> Community -> Mailing Lists -> Oracle-L -> SQL*LOADER-524 -- HELP

SQL*LOADER-524 -- HELP

From: grace lim <mglim_at_softhome.net>
Date: Mon, 16 Oct 2000 10:01:42 +0800
Message-Id: <10650.119255@fatcity.com>


gurus,

i'm trying to use sql loader to load data from a text file into a table and getting this error....

SQL*Loader-524: partial record found at end of datafile (c:\sqlldr\glacct.ctl)

i try removing the ~ in my glacct.ora and still have the same error....

what shall i do?

here's the glacct.ctl
load data
infile 'c:\sqlldr\glacct.ora'
into table gl_accts_work
fields terminated by '~'
(acct)

glacct.ora
POS10~
Grace Lim
Suy Sing Comm'l Corp. Received on Sun Oct 15 2000 - 21:01:42 CDT

Original text of this message

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