-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|