As title, now found that when the import file contains an empty, SQLLDR import complains: "record 3: abandoned - all the columns are empty"

Ask any parameter can be ignored under the wrong, or support the import empty record


Such as data is as follows:
Field 1 field 2 3
A b c

A2 b2 c2

CodePudding user response:

Processing this file, remove the space for the new file;

Sed and awk these two tools, can achieve this goal

CodePudding user response:

Processing file is feasible, but the cost is larger, the logic has a ready-made tool can be adjusted, or you also have to modify the tool,
So I hope can be handled by CTL and parameters inside the

reference 1st floor wmxcn2000 response:

processing this file, remove to save space in the new document;

Sed and awk these two tools, can achieve this

CodePudding user response:

Try, very simple
The cat filename | sed '/^ $/d' & gt; The file name

CodePudding user response:

Java code do it, don't have the environment, that is to say, go processing files this way

CodePudding user response:

reference 4 floor linym3k response:

Java code do it, don't have the environment, that is to say, go processing files this way impassability

Java generated file, don't write a blank line,