Recently, the ten million data, considering the production excel file too slow, so use sqluldr2 tool, use no problem in the server, but through the Java appeared to invoke the command line identifier to lack the double quotes "ORA - 1740", I thought it was the SQL problems, but the copy down to perform, but there was no problem,

CodePudding user response:

I thought it was a Linux environment problems, then, I put the query encapsulated into SQL script, use sqluldr2 read SQL file, still the same problem,

CodePudding user response:

Problem has been solved, is due to under Linux, tool reads the text, there is a newline caused by the escape, which leads to the oracle SQL statements can't normal recognition, solution: when we are joining together the SQL statement, don't be too long, the best query each field in the end, his force line breaks,

CodePudding user response:

Brothers, the code still there? Can you explain it refer to?