RE: Dblink between Oracle 7.3 and 9.2

From: EPS - DBA (Group) <dbamail_at_police.edmonton.ab.ca>
Date: Wed, 2 Jun 2004 13:27:12 -0600
Message-ID: <10AA67C37F89FF41833762DBD1D2B61106B30775@qe02.police.edmonton.ab.ca>

We need 7.3.4 to access 9.2 and vice versa. We created views with database links on the 8.1.6 that way the 7.3 and the 9.2 can get to each other's data.

Debbie

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

From: Scott A. Machado [mailto:smachado_at_ix.netcom.com] Sent: Tuesday, June 01, 2004 12:26 PM
To: oracle-l_at_freelists.org
Subject: RE: Dblink between Oracle 7.3 and 9.2

In my case my 9.2 db needed access to 7.3.4 objects, so I put the 7.3.4 tables into the 8.1.7. database and then just pointed synonyms on both sides to them. You can't create views in the middle db that point to 7.3.4 objects, because the dblink will still complain. Materialized views would work if your data is relatively static.

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Ron L. Sent: Tuesday, June 01, 2004 10:32 AM
To: oracle-l_at_freelists.org
Subject: RE: Dblink between Oracle 7.3 and 9.2

Do you mean tables in the 8.1.7 database or do you mean synonyms? I want the live data fro 9.2.

Ron

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Scott A. Machado Sent: Tuesday, June 01, 2004 9:29 AM
To: oracle-l_at_freelists.org
Subject: RE: Dblink between Oracle 7.3 and 9.2

I created a middle 8.1.7 database, created the tables in the middle db, and then created public synonyms to point to them. Works like a charm.

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Tuesday, June 01, 2004 9: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


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

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

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


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

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

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 Wed Jun 02 2004 - 14:24:02 CDT