XPost: comp.database.oracle, comp.databases.oracle.misc, comp.da   
   abases.oracle.server   
   XPost: comp.databases.oracle.tools   
   From: Jane@dossss.com   
      
   "Pete's"  wrote in message   
   news:6724a51f.0310141358.c7ca95a@posting.google.com...   
   > "Jane"  wrote in message   
   news:...   
   > > 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!!   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)