Re: load data

From: Bob Jones <email_at_me.not>
Date: Wed, 30 Aug 2006 01:10:49 GMT
Message-ID: <tA5Jg.5234$q63.4132@newssvr13.news.prodigy.com>

"Vince" <vinnyop_at_yahoo.com> wrote in message news:1156892302.815710.179040_at_i3g2000cwc.googlegroups.com...
>
> Bob Jones wrote:
>> "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.
>
> Access 2000 and later, tables can be as big as 2gb. Access97 has a 1gb
> limit.
>

Those are limits. Exporting data, sending it to Oracle server, and then loading it is a 3 step process, verses just inserting. Which one is faster? I will let OP be the judge. Received on Tue Aug 29 2006 - 20:10:49 CDT