Re: Long transfer via ODBC.

From: Kevin A Lewis <KevinALewis_at_Hotmail.com>
Date: Fri, 23 Jul 1999 11:17:51 +0100
Message-ID: <GdXl3.8553$N47.847@newreader.ukcore.bt.net>

Try an extract to a flat file and use SQL*Loader to upload into Oracle

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Feldman <wasp97_at_polbox.com> wrote in message news:6eUl3.3442$D4.55517_at_news.tpnet.pl...
> Hi,
>
> I have little problem. I want to transfer via ODBC driver data from access
> to oracle8.
> It's something about 700.000 records. On the server side I have Oracle
> instance
> with 500MB. It works on the server Dell PE4300 (2xproc PIII, 1Gb RAM, HDD
in
> RAID5) with Novell NetWare 4.11.
> It very funny, but transfer is so long. Something about 5 hours. I don't
> know what to do
> to make it faster.
>
> Best Regards,
>
> Lukasz Feldman
> DT Centrum
>
>
Received on Fri Jul 23 1999 - 05:17:51 CDT