Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: load data

Re: load data

From: Vince <vinnyop_at_yahoo.com>
Date: 28 Aug 2006 08:52:16 -0700
Message-ID: <1156780336.488936.101710@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. Received on Mon Aug 28 2006 - 10:52:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US