Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE : SQL*LOADER-524 -- HELP
Grace,
Try adding a carriage-return after your last line. Lookes like the 'truncated' SQL*Plus message.
-- Regards, Stephane Faroult email: sfaroult_at_oriolecorp.com Oriole Corporation Voice: +44 (0) 7050-696-269 Fax: +44 (0) 7050-696-449 Performance Tools & Free Scripts ------------------------------------------------------------------ http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs ------------------------------------------------------------------Received on Mon Oct 16 2000 - 03:20:02 CDT
>
> 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
![]() |
![]() |