On Fri, Aug 21, 2009 at 2:34 AM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote: > 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. > That sounds like a win. :) Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist