Re: SQLLDR or UTL_FILE package? Which is faster?

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_at_gmail.com> 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_at_gmail.com> 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_at_gmail.com > 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.

--
http://www.freelists.org/webpage/oracle-l