Home » SQL & PL/SQL » SQL & PL/SQL » db link between 10g and 12c (10g 12c)
db link between 10g and 12c [message #647114] Tue, 19 January 2016 23:30 Go to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
please confirm if db link created on 10g is compatible/supported with 12c database.

we are trying to fetch the 12c data using db link on 10g db server.

more surprising, select and view created on 10g are working fine but materiliazed view is not working while it is getting created and refreshed successfully.

regards,

Report message to a moderator

Re: db link between 10g and 12c [message #647115 is a reply to message #647114] Wed, 20 January 2016 00:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

See Compatibility matrices and differences between editions

Report message to a moderator

Re: db link between 10g and 12c [message #647130 is a reply to message #647115] Wed, 20 January 2016 04:05 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which 10g version do you use? Unless I'm wrong, 10.2.0 works with 12.1.0, but 10.1.0 has never been supported.

mshrkshl

materiliazed view is not working while it is getting created and refreshed successfully.

What does it mean? It is created, it is refreshed, so - what happens when you select from the MV? Do you get any error? If so, which one?

Report message to a moderator

Re: db link between 10g and 12c [message #647133 is a reply to message #647130] Wed, 20 January 2016 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Unless I'm wrong, 10.2.0 works with 12.1.0


It depends on the full version, see the note I gave.

Report message to a moderator

Re: db link between 10g and 12c [message #647134 is a reply to message #647133] Wed, 20 January 2016 04:25 Go to previous message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I did. Went to Metalink as well. Tables specify these versions (i.e. "10.2.0"). On the other hand, I didn't spend much time on that nor went into details so - yes, I believe you're right.

Report message to a moderator

Previous Topic: Use cursor output in the IN CLAUSE
Next Topic: How To Get JV/34 as JV/0034 or JV/034 as JV/0034 or JV/0034 as JV/0034 using regular expression
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 22:16:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.