Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

dblink from oracle 9i point to oracle 8i

Go to solution
malay boy
Trusted Contributor

dblink from oracle 9i point to oracle 8i

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

uhm!!!! any issue ?.

There are three person in my team-Me ,myself and I.
Peter Godron
Honored Contributor

Re: dblink from oracle 9i point to oracle 8i

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
Respected Contributor

Re: dblink from oracle 9i point to oracle 8i


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 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.

Look before you leap