Re: SQLLDR or UTL_FILE package? Which is faster?

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

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