Re: load data

From: Bob Jones <email_at_me.not>
Date: Mon, 28 Aug 2006 23:49:37 GMT
Message-ID: <liLIg.17628$kO3.10195@newssvr12.news.prodigy.com>

"Vince" <vinnyop_at_yahoo.com> wrote in message news:1156780336.488936.101710_at_b28g2000cwb.googlegroups.com...
>
> Bob Jones wrote:
>> <soalvajavab1_at_yahoo.com> wrote in message
>> news:1156518262.158259.58550_at_h48g2000cwc.googlegroups.com...
>> >_ what is the best approach to load MS Access data to Oracle table?
>> >
>>
>> Create a link from Access and then insert into Oracle tables.
>
> This approach works reasonably well for smaller amounts of data. The
> export then load via SQL*Loader is much faster.
>

How big can Access tables be? By the time you finish writing export and load scripts, I am already done with the inserts. Received on Mon Aug 28 2006 - 18:49:37 CDT