This content has been marked as final. Show 2 replies
Pl post OS and database versions. Have you tried to use just the TERMINATED BY clause and omit the OPTIONALLY ENCLOSED BY clause ?
Oracle version is 22.214.171.124.0
OS is Windows 6.1.7601
I can't remove the "optionally enclosed by" clause because we're getting the data from another system. Fortunately this is test data and this particular combination of characters is unlikely to occur in production data.