Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle is painfully slow when doing massive INSERTs
On Wed, 11 Mar 1998 20:00:17 +0100, "Morten Myrvold" <someone_at_somwehere.no> wrote:
>
>Hi all...
>
>Hope someone can help me with this one (kinda newbie question):
>
>I've written a utility that essentially transfer tables from one database to
>another (different RDBMSes). To transfer a table consisting of
>30000-something rows takes 18+++ mins to complete (number of columns doesn't
>seem to affect this). I'm using an ODBC cursor for selecting rows from the
>source DB and a dynaset (OO4O21) for inserting into Oracle.
>
>What I'd like to know is: Is there a way for me to speed up this process.
Write the data to a file and use direct path sql*loader. Received on Thu Mar 12 1998 - 00:00:00 CST