I have found a small mistake in the SQL Loader control file generated by AUL/MyDUL, if you use the control file directly, it will skip the first row of the text file. That's because I copy the SQL Loader parameters from another text unload tool which put the column name at the first line, while AUL/MyDUL did not put the column name as the first line of recovered text file. Please remove the "SKIP=1" in the "OPTIONS(..." line. So sorry for the mistake.
Old example of the control file:
--
-- Generated by AUL/MyDUL, for table hr.test
--
OPTIONS(DIRECT=TRUE,READSIZE=4194304,ERRORS=-1,SKIP=1,ROWS=50000)
I have updated the software and uploaded it, new example:
--
-- Generated by AUL/MyDUL, for table hr.test
--
OPTIONS(DIRECT=TRUE,READSIZE=4194304,ERRORS=-1,ROWS=50000)
If you used to recover data by AUL/MyDUL in text format, please re-input the first line of the text file. Sorry again!