Q

Creating db links from Oracle 10g to 8i

An Oracle user asks about creating db links from Oracle 10g to 8i.

I have 2 databases, one in Oracle 8i and the other in Oracle 10g. I have to create views/materialized views in Oracle 10g to access and modify the tables in Oracle 8i using db links. The views created in Oracle 10g are transactional, i.e, DMLs are performed frequently. The views can be simple and complex views and will hit 50-60 tables in Oracle 8i.

The question is: Is it a feasible solution to have views/materialized views created in one database and have them

access 50 tables in another database through db link, considering that there will be DMLs happening every day?

You may have connectivity issues for db links from 10g to 8i. Others have experienced problems trying to connect these two versions.

As for the MV's…I would not create a MV which uses remote tables. Instead, I'd create the MV in the remote database. Then I'd use the db link to see the MV in the remote database.

This was first published in May 2008

Dig deeper on Oracle database administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close