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