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
------------------------------------------------------------------
>
> 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
Received on Mon Oct 16 2000 - 03:20:02 CDT
