Do you have to specify every field on the table that you are loading? If you set column defaults in the table and you don't specify them in the sqlldr control file will that work?
We have a file that only has info for about half of the columns in the table we are loading. So what we want to do is load those fields and default the other columns to NULL. The problem that we are having is that sqlldr doesn't like the fact that not all of the columns are specified. Any help would be appreciated.
I am not sure if you have got the answer you are looking for, but I have discovered this lately.
I was loading a delimited file with n columns and i had to skip columns in between, like load column 1, 3, 10 and so on... to suffice this, there is an utility in sqlldr called FILLER, you can give any dummy name and just say FILLER.
In case of a fixed file, just skip off those positions and columns in your CTL file. I hope I have answered your question.