Re: SQLLDR or UTL_FILE package? Which is faster?

  • From: "Amol Umbarkar" <amolumbarkar@xxxxxxxxx>
  • To: srinivasanram2004@xxxxxxxxx, Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 15 Jun 2007 10:39:16 +0530

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


Other related posts: