| 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: 21808
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
