Re: Oracle 9i client connectivity to Oracle 7.1.4

"Pete's" <empete2000_at_yahoo.com> wrote in message news:6724a51f.0310141358.c7ca95a_at_posting.google.com...
> "Jane" <Jane_at_dossss.com> wrote in message
 news:<ycVib.27287$Eh3.9859104_at_news4.srv.hcvlny.cv.net>...
> > Hi All,

>>
> > How do I query a remote Oracle 7 database from Oracle 9i? My queries
 will
> > run from a stored procedure in the 9i database.
 

> Oracle only supports dblinks from 9i db's to 8.0.6 db's. You should
> upgrade. However, to continue down your path, you would need to setup
> a database in between the two so that 9i would eventually talk to the
> 7.1.4 db. i.e. db link from 9i to 8.0, then db link from 8.0 to
> 7.1.4. The 8.0 db would probably need synonyms to point to whatever
> you are accessing on 7.1. Not sure if the 8.0 to 7.1 link will work,
> but, try it.

Thanks Pete. I just tried this and it works!! Received on Wed Oct 15 2003 - 00:45:44 CEST