Home » RDBMS Server » Server Utilities » oracle8i sqlldr (xp)
oracle8i sqlldr [message #383193] Tue, 27 January 2009 11:57 Go to next message
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 Go to previous message
Littlefoot
Messages: 20895
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.
Previous Topic: Input data file as a parameter in control file of sql loader
Next Topic: converting images from long raw to jpeg.
Goto Forum:
  


Current Time: Mon Dec 05 19:02:32 CST 2016

Total time taken to generate the page: 0.10237 seconds