dblink from oracle 9i point to oracle 8i

[malay boy]

Hi,
Anybody have try this.Create a dblink at Oracle 9i and that dblink point to Oracle 8i database.

uhm!!!! any issue ?.

Regards
mB

[Peter Godron · Accepted solution]

Hi,
have just created dblink from 10g to 8i and it worked ok.
Only thing to note was to replace SERVICE_NAME with SID in tnsnames.ora.

So add the 8i host to your tnsnames.ora on 9i, restart the listener and create your db link.

create database link fred connect to system identified by manager using '8imachine';

I checked with:
select * from v$version@fred;

[Frank de Vries]

Hi,

We have just finished installing
an Oracle 9i (9.2.07) and we
needed to create some private dblinks to be used in synonyms to access a schema from
a 8.1.7.4 database on a different node

Worked fine.
I needed to ensure the correct tnsnames file
is file found and I always test my dblink first
with a select * from dual@dblink
and it came up positive.

No issues I am afraid.