no terminator found after TERMINATED and ENCLOSED field
721646Mar 29 2011 — edited Mar 30 2011Hi,
I am trying to load data from a flat file to Oracle table using SQLLDR.
Control File parameters
Field Separator is ~
Optionally enclosed by "
however, there is some data in my data file as follows:
"testdata"~"test"data1"~1234
If we see the second column data, there are three quotation marks. I want to skip the second one and load data into column as testdata1.
However, SQLLDR is throwing the error mesage no terminator found after TERMINATED and ENCLOSED field.
How can I let SQLLDR to overcome/overwrite the second quotation mark ? Or, tell SQLLDR to read column until field separator is found?
Regards,
k