Re: Database LInk - V6 to V7 -- is it possible?

From: Bill Beaton <beatonb_at_cadvision.com>
Date: 1996/05/16
Message-ID: <4nfouo$19v8_at_elmo.cadvision.com>#1/1

In article <4ncn2e$9nl_at_hdxx05.telecom.ptt.nl>,

        C.deWaaij_at_PTT-Telecom.NL (Cor de Waaij) writes:
>>>kissing_at_oneworld.owt.com (Bruce Kissinger) wrote:
>>>
>>>>I'm having problems trying to set up a database link from an Oracle 6
>>>>database to an Oracle 7. Does anyone know if this is supposed to
>>>>work?
>>>patch number was 236812, but YMMV.
>>
>>Note also that is is no longer possible to create a db link between v6 and v7.1
>>and higher. That is no bug, but a development decision...

We did find a workaround for our site ...

	Set up a database on any box using ORACLE 7.0.16
	Setup a user on this instance that has links to the 7.[123] database
		as the applications require.
	Change all V6 database links to route thru the links on the 7.0.16
	instance.

There is certainly more network overhead, and a fair load on the 7.0.16 box, but all applications have been able to keep running. The logic is that 7.0.16 can communicate gracefully with both V6 using SQL*NET V1, and to 7.x using SQL*NET V2.

I wonder what will happen when and if SQL*NET V3 appears?

Bill Received on Thu May 16 1996 - 00:00:00 CEST