I am trying to load data into a table rcv1 using sql*loader, but
I keep getting the following error.
SQL*Loader-524: partial record found at end of datafile (rcv1.ctl)
ctl file is as below:
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(LOC_ID, RCV_DATE, MSG_ID,RCV_TIME, PHONE, UNWANTED, WHO)
S570-1234, 01-05-30, 11885, 11:12:40, 6109384567, =,ttyv
Has any body come across this error !!
make sure that you don't have any extra trailing spaces or lines beyond your file
I check & rechecked
But there is no space or line beyond the last text in the file.
I just entered a couple of "return"(enter) at the end of the file.
And then I could load data into the table !!!
Is this a know oracle 8.1.5 bug?
It was not a bug. The loader was looking for an end-of-file or end-of-line character to terminate the execution and since you didn't have it on the first time, it had given that error. Now the retun had placed the EOF and in turn it was happy to see the end-of-file termination at the end of your control file.
Hope this would help you to understand it. IF you need more detail on how to write control file for the sql-loader, check http://technet.oracle.com and do a search on the sql*loader