-
Hi
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:
LOAD DATA
INFILE *
BADFILE '/opt/../rcv1.bad'
DISCARDFILE '/opt1/../rcv1.dsc'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(LOC_ID, RCV_DATE, MSG_ID,RCV_TIME, PHONE, UNWANTED, WHO)
BEGINDATA
S570-1234, 01-05-30, 11885, 11:12:40, 6109384567, =,ttyv
Has any body come across this error !!
Any ideas
Thanks,
nk
-
make sure that you don't have any extra trailing spaces or lines beyond your file
Sam
-
I check & rechecked
But there is no space or line beyond the last text in the file.
nk
-
luck hit
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?
And ideas!
thanks
nk
-
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
Sam