oracle8i sqlldr [message #383193] |
Tue, 27 January 2009 11:57  |
Spiritual
Messages: 18 Registered: July 2008 Location: Pakistan
|
Junior Member |

|
|
hi
i am trying to load data using utility sqlldr.
i have data in txt file like belove
10001,"imran ahmad",100,50
10002,"sobia imran",50,25
and control file have below statement
LOAD DATA
INFILE 'd:\mydata.txt'
INTO TABLE emp
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(empno,empname,sal,comm)
when i run commant
sqlldr scott/tiger control=d:\load.ctl
error dislay
SQL*LOADER-524: PARTIAL RECORD FOUND AT END OF FILE (D:\LOAD.CTL)
WHAT SHOLD I DO
|
|
|
Re: oracle8i sqlldr [message #383215 is a reply to message #383193] |
Tue, 27 January 2009 15:58  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
It appears that you have hit a bug 735710; if so, add the LINEFEED to the end of the file. How? Open the file, go to the last line and hit <Enter>, save the file, run SQL*Loader once again.
|
|
|