Re: Oracle is painfully slow when doing massive INSERTs

From: Morten Myrvold <someone_at_somwehere.no>
Date: 1998/03/13
Message-ID: <6eb0kp$i4r$1@elle.eunet.no>#1/1

Keith Boulton wrote in message <35081fcd.5119641_at_read.news.global.net.uk>...
>
>Write the data to a file and use direct path sql*loader.
Been there; I had a script that, when executed on our source database, generated table dump files and *.CTL files for the loader along with a "master script" that loaded all tables in the correct order (using SQL*Loader).
Unfortunately, SQL*Loader doesn't seem to handle LONG columns, and our database contains a quite a lot of them.... Also; I wasn't able to correctly convert CR/LF's and other escape sequences to some format that SQL*Loader could understand. Therefore, this method was never implemented. Instead, I tried creating my own app using ODBC and OO4O21, which I may add: works perfectly (except for the looooooong loading time... ;-( )

Morten Received on Fri Mar 13 1998 - 00:00:00 CST