Re: load data

From: Vince <vinnyop_at_yahoo.com>
Date: 29 Aug 2006 18:43:45 -0700
Message-ID: <1156902225.453219.109490@p79g2000cwp.googlegroups.com>

Bob Jones wrote:
> "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.

Agreed. Although the second step may not be necessary. I used SQL*Loader directly from my PC, so it was just export and load. Received on Tue Aug 29 2006 - 20:43:45 CDT