FAQ
This is working, but updates to the 9.2 database are very slow. Any
ideas?

Thanks!

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
On Behalf Of Scott A. Machado
Sent: Tuesday, June 01, 2004 1: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
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
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
=20
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

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, =
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received =
this message by mistake, then delete the e-mail message.
Thank you.
--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 8, '05 at 4:14p
activeJun 9, '05 at 12:49p
posts2
users2
websiteoracle.com

2 users in discussion

Jared Still: 1 post Smith, Ron L.: 1 post

People

Translate

site design / logo © 2022 Grokbase