RE: Dblink between Oracle 7.3 and 9.2

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 1 Jun 2004 10:25:22 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AB6A@usahm018.exmi01.exch.eds.com>

Oracle does not support communication via db links between version 9 and any version below 8.

You might try placing db links and synonyms to and from the two non-compatible systems on a version of Oracle that both of the others can communicate with, that is, 9 -> 8 -> 7.3 where -> represents a remote synonym and link to the database version to the right. There are limitations to this approach such as the objects in question should be simple tables consisting of common data types like varchar2, number, and date etc....

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Tuesday, June 01, 2004 10:17 AM
To: oracle-l_at_freelists.org
Subject: Dblink between Oracle 7.3 and 9.2

We have several applications still on Oracle 7.3.4 that net to talk to our upgraded Oracle Financials on 9.2. The applications use Dblinks which do not work between 7.3 and 9.2. Has anyone run across this problem and cam up with a solution?

Thanks!
Ron Smith

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Jun 01 2004 - 09:23:02 CDT