Home » SQL & PL/SQL » SQL & PL/SQL » DB Link between different oracle versions 9i to 10g
DB Link between different oracle versions 9i to 10g [message #193400] Sat, 16 September 2006 04:10 Go to next message
nagaraju_orafaq
Messages: 2
Registered: September 2006
Location: Hyderabad
Junior Member
Dear All,

Its urgent...

We are working on dblink related issue.
I've to create a dblink in 9i and the target db is in 10g, is this possible..?
Is there any constraint on the dblink like the dblink from lower version to higher version is not possible...?

Please provide pointers on this.

Cheers...
Nag

Report message to a moderator

Re: DB Link between different oracle versions 9i to 10g [message #193527 is a reply to message #193400] Mon, 18 September 2006 02:12 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

What problems do You have creating the link?
- Error messages are always easier to address.

I have used links from 10g to 9i and 8i, but I do not have expirence in using link from lower versions to 10g.
- You might have an issue there, but try it out!

Br
Kim

Report message to a moderator

Re: DB Link between different oracle versions 9i to 10g [message #193546 is a reply to message #193527] Mon, 18 September 2006 03:23 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I'm not wrong, there should be no problem in creating a database link between 91 and 10g.

However, if you had to create a DB link between 8i and 10g, that wouldn't be possible - not directly. You should have a 9i instance "in between" and make two hops - 8i -> 9i -> 10g.

Report message to a moderator

Previous Topic: Zero rows in User_Tables
Next Topic: Sql query to get the primary key column of the table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 07 06:29:42 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.