sql*loader question

[crsdev]

Hello Friends,

I was loading a table from a '|' seperated file.
An addition of column(account_id) was requested,
so i altered the table and added the column, the column got added at the end.

this was in the coltrol file
xxx1 NULLIF xxx1='null',
account_id FILLER,
xxx2 NULLIF xxx2='null',

how can i modify the control file so that the data gets loaded in the proper column.

Thanks for the help in advance.

 

[LKBrwnDBA]

The order of the columns in the control file must reflect the order of the fields in the input file.

Columns in control file will be mapped to table columns by the NAME.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb