Re: sql loader help

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-l


Other related posts: