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.

Follow-Ups:

Re: SQLLDR or UTL_FILE package? Which is faster?
From: Amol Umbarkar

References:
- RE: SQLLDR or UTL_FILE package? Which is faster?
  - From: Ram Srinivasan

Other related posts:

» RE: SQLLDR or UTL_FILE package? Which is faster?
» Re: SQLLDR or UTL_FILE package? Which is faster?
» RE: SQLLDR or UTL_FILE package? Which is faster?
» Re: SQLLDR or UTL_FILE package? Which is faster?
» Re: SQLLDR or UTL_FILE package? Which is faster?
» Re: SQLLDR or UTL_FILE package? Which is faster?

Browse oracle-l