Re: Loading data from oracle 8i to 10g

Ben Rum wrote:
> "Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
> news:1106739777.750992.318550_at_f14g2000cwb.googlegroups.com...
> >
> > Ben Rum wrote:
> > > Newby alert - coming from MS SQL background (hisss..)
> >
> > Please be specific.
> > 1) Are you exporting from 8i and importing into 10g? OR
> > 2) Are you just doing selective data load from 8i to 10g (Via flat
file
> > and sqlldr)?
> >
>
> Apologies - the 10g instance will be pulling selective data directly
from
> the 8i via sqlldr.
>
> The overall outcome will be a scheduled (hourly) load whereby the 10g
server
> connects to 8i and pulls across what it needs.

Then sqlldr (It's an external utility run from the command line) may not be a good option... it is primarily used to PUSH data into the database from an existing flat file. What you are looking for is a DBLINK between 10g and 8i. The issue could be difference in releases. You won't be able to connect to anything below 8iR3 (8.1.7.x) from 10g for a data PULL. Even in 8iR3, you would have to be atleast on 8.1.7.4 patchset. So you are left with pushing data from 8i to 10g. You can setup Oracle job to do this unattended.

You can read more about DBLINK at http://tahiti.oracle.com Regards
/Rauf Received on Wed Jan 26 2005 - 08:11:28 CST