Re: SQLLDR or UTL_FILE package? Which is faster?

From: Ajeet Ojha <ajeeto_at_gmail.com>
Date: Fri, 15 Jun 2007 09:59:13 +0530
Message-ID: <a8304bb50706142129m225dd143q22e992fa866f1092@mail.gmail.com>

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

Received on Thu Jun 14 2007 - 23:29:13 CDT