From oracle-l-bounce@freelists.org Tue Jun 1 13:22:39 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i51IMOu28255 for ; Tue, 1 Jun 2004 13:22:34 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i51IME628220 for ; Tue, 1 Jun 2004 13:22:24 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 220F872C334; Tue, 1 Jun 2004 13:09:03 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21548-23; Tue, 1 Jun 2004 13:09:03 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7100772C323; Tue, 1 Jun 2004 13:09:02 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 01 Jun 2004 13:07:43 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A52C272C372 for ; Tue, 1 Jun 2004 13:07:42 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20509-87 for ; Tue, 1 Jun 2004 13:07:42 -0500 (EST) Received: from gemini2.roman.com (unknown [192.234.169.159]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5001972C2E5 for ; Tue, 1 Jun 2004 13:07:42 -0500 (EST) Received: from SMACHADOLT ([89.89.2.213]) by gemini2.roman.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id MC3N88GJ; Tue, 1 Jun 2004 13:29:50 -0500 From: "Scott A. Machado" To: Subject: RE: Dblink between Oracle 7.3 and 9.2 Date: Tue, 1 Jun 2004 13:25:48 -0500 Message-ID: <00f801c44805$dc9e6160$d5025959@SMACHADOLT> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: <270A0BDDFDE54E41B78F0F06D82A66B8508A6B@okcexg3.kmg.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1715 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: smachado@ix.netcom.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Smith, Ron L. Sent: Tuesday, June 01, 2004 10:32 AM To: oracle-l@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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Scott A. Machado Sent: Tuesday, June 01, 2004 9:29 AM To: oracle-l@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@freelists.org [mailto:oracle-l-bounce@freelists.org] Sent: Tuesday, June 01, 2004 9:17 AM To: oracle-l@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@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@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@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@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 -----------------------------------------------------------------