Re: SQLLDR or UTL_FILE package? Which is faster?
- From: "Ram Srinivasan" <srinivasanram2004@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Jun 2007 13:02:48 -0400
All:
Thank you very much.
I also checked with AskTom site, and SQLLDR is definitely faster and
superior for loading external data in 8.1.7 env. However after 9i, we can
use external tables.
Thanks to every one for their input. This DBA group is wonderful.
Ram SRinivasan
On 6/15/07, Amol Umbarkar <amolumbarkar@xxxxxxxxx> wrote:
Ram,
Although external tables are not available on your environment (8.1.7 as
per your first post), you can simulate it. But i would still go for SQL*LDR
for the following reasons:
- Better performance. Options like Direct path insert with parallel
loading capabilities is too good for performance. Ofcourse there are some
tradeoffs you might want to look into.
- Less coding means less defects.You can spend more time to think about
loading strategies than your PLSQL code
- There are several command line options. So you can easily switch between
them. A PLSQL loading routine requires code change for everything.
Thanks,
AMol
On 6/15/07, Ajeet Ojha <ajeeto@xxxxxxxxx> wrote:
>
> If you have oracle version 9i then why not try external tables - which
> will take almost no time in converting a file into a table.
>
> Regards
> Ajeet
>
>
> On 6/15/07, Ram Srinivasan <srinivasanram2004@xxxxxxxxx > wrote:
> >
> > All:
> > Is SQLLDR faster or UTL_FILE utility faster?
> > For loads of 130 million rows with about 200 columns, which tool is
> > better?
> > We are on 8.1.7 on Sun server.
> >
> > Thanks for your input.
> >
> > --
> > Sincerely
> > Ram Srinivasan
> > Charlottesville, VA.
> >
>
>
--
Sincerely
Ram Srinivasan
Charlottesville, VA.
Other related posts:
