By default, sql loader use \n as the line terminator. i.e. as soon as it sees a \n, it treat anything behind it as the new line.
However, one of columns in my output file also has \n inside. This did confuse SQL Loader since it thought that's the end of the line while there are still many columns after that.
So how can get this problem resolved?
I can regenerate the data file, so that file will be a different line terminator (do differentiate from \n). But can I specify the new terminator in the SQL Loader's control file? If yes, how?
I've been looking at different resources, but haven't got any luck. Your help is very much appreciated!
Click Here to Expand Forum to Full Width