Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Basic Sqlldr question

Re: Basic Sqlldr question

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 12 Dec 2005 09:46:22 -0800
Message-ID: <bf46380512120946t66f74e02oedcdb68b6a0415a0@mail.gmail.com>


On 12/12/05, rjamya <rjamya_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 12 2005 - 13:03:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US