one all null row is always in discard file of sqlldr

Hi All,

My DB is 11.1.

I used spool to generate a formatted flat data and load it to oracle with sqlldr. I found everything was fine except that the discard file was always generated.

Its content is ~~~, which is line seperator specified in control file.

But before loading, I cleansed the data with the following command and it seems that the empty line should be in the data file any more.

sed '/^ *$/d' S_PROD_INT_PLC_BK_LEON.dat > S_PROD_INT_PLC_BK_LEON.dat1
 mv  S_PROD_INT_PLC_BK_LEON.dat1 S_PROD_INT_PLC_BK_LEON.dat