Re: SQLLDR or UTL_FILE package? Which is faster?

  • From: "Ajeet Ojha" <ajeeto@xxxxxxxxx>
  • To: srinivasanram2004@xxxxxxxxx
  • Date: Fri, 15 Jun 2007 09:59:13 +0530

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: