Re: SQL*NET V1 / Oracle 8

It is not possible to connect to Oracle8 with SQL*Net V1

A possible workaround is to use Oracle 7.2 as a link between the client application and Oracle8:

1. Install Oracle8 in a new ORACLE_HOME
2. Migrate your 7.2 database to Oracle8
3. Create a new Oracle7.2 database
4. For each table your application should access, create a database link in the 7.2 database that points at the table in Oracle8.
5. Create synonyms for all remote tables

The same apply for stored objects, views, etc.

This should make the access to the Oracle8 tables transparent for the client application.

HTH,
Jesper

On Wed, 08 Sep 1999 14:08:58 GMT, sg_office_at_my-deja.com wrote:

>We have Oracle 7.2 servers which I'd like to
>upgrade to Oracle 8, but we also have some clients
>running SQL*NET V1 which can't be upgraded, at
>least not in the short term. Is there any way to
>connect these clients to Oracle 8?
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Sep 10 1999 - 16:18:45 CDT