Re: sql loader help
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Fri, 21 Aug 2009 12:34:13 +0300
Message-id: <4A8E6A15.9030003_at_inter.net.il>
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.
Date: Fri, 21 Aug 2009 12:34:13 +0300
Message-id: <4A8E6A15.9030003_at_inter.net.il>
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.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 21 2009 - 04:34:13 CDT