Re: Basic Sqlldr question

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: rjamya <rjamya@xxxxxxxxx>
  • Date: Mon, 12 Dec 2005 09:46:22 -0800

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

Other related posts: