Just to let you know the final results.Loading of data to input table and then copy the data to the master table with corrections: 40 minutes. Doing the corrections in the text file and loading it to the master file with sql loader: 5 minutes.
BTW - Thanks to Jared for providing a link to Microsoft Unix extensions. Adar Yechiel Rechovot, Israel Yechiel Adar wrote:
Thank you all. I decided to use the "edit the data file" advice.This is windows so sed will not work, but I used change.exe instead and it works now fine.
-- //www.freelists.org/webpage/oracle-l