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
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
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: 20891
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.
Previous Topic: Zero rows in User_Tables
Next Topic: Sql query to get the primary key column of the table
Goto Forum:
  


Current Time: Sun Dec 04 16:33:11 CST 2016

Total time taken to generate the page: 0.09526 seconds