| Regarding views and synonyms [message #220850] |
Thu, 22 February 2007 06:42  |
Suresh B
Messages: 10
Registered: October 2003
|
Junior Member |
|
|
One of our production database is being upgraded from its current 8i version to 9i. This results in impact on the db link, as db links between Upgraded database (Oracle version 9.2.0. and destination database (Oracle version 7.3.4) are no longer supported by Oracle Corporation.
The above db link issue between Oracle 9i and Oracle 7 versions can be handled by using an intermediate 8i database in between the 7 and 9 versions. This results in 9i version interacting with 8i version and 8i with 7 version without any problems.
The solution can be attained by creating views on the intermediate database pointing to the 7.3.4 DB using the database links. Synonyms referring to these views on the intermediate database would be created on the 9.2.0.8 database with the same name as that on the intermediate database using db links.
Here would like to know that, is the view or synonym will give the better performance when we fetch/transfer the data thru intermediate database.
Your expert comments would really help me.
Regards,
Suresh.
|
|
|
|
|
|
|
|
|
|
| Re: Regarding views and synonyms [message #220869 is a reply to message #220850] |
Thu, 22 February 2007 08:08  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
| Suresh B wrote on Thu, 22 February 2007 07:42 |
The above db link issue between Oracle 9i and Oracle 7 versions can be handled by using an intermediate 8i database in between the 7 and 9 versions. This results in 9i version interacting with 8i version and 8i with 7 version without any problems.
The solution can be attained by creating views on the intermediate database pointing to the 7.3.4 DB using the database links. Synonyms referring to these views on the intermediate database would be created on the 9.2.0.8 database with the same name as that on the intermediate database using db links.
|
Wow, I'd just like to add that I thought I was the only person in the world who had to do something like this. At one time, we had 7.3, 8i, 9i and 10g all running different production databases and I had to use the 8i database to create a "bridge" between 10g and 7.3 and vice versa.
It might not apply to you, but Forms will not work using this method due to the way ROWID has changed through the versions.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
.