On 12/12/05, rjamya <rjamya@xxxxxxxxx> wrote: > > > And Jared, thanks for the wonderful > script<http://www.jaredstill.com/content/dump.html>you have on your site to > dump a table for sqlldr. I used it to generate a > control file to upload the data. Now instead of couple of hours to load > about 2m rows (thru perl process), it takes about 220 seconds using sqlldr. > and since this will be done every hour, The time savings are huge. > > You're welcome. I sometimes use it for that same reason, as I did for this test case. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist