Re: sql loader help
Date: Fri, 21 Aug 2009 12:34:13 +0300
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.
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.