Creating db links from Oracle 10g to 8i

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

Published: 01 May 2008

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...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

Dig Deeper on Oracle database administration

How to perform an Oracle 8i to 10g migration Oracle expert Brian Peasland explains how to perform an Oracle 8i to 10g migration when moving to Oracle 10g R2 with these step by step migration tips.

Failed stored procedure through db link in Oracle An Oracle user asks why a stored procedure through db link from Oracle 10g to 8i is failing.

Oracle block size during import An Oracle user asks if there will be any problem with block sizes during import.

Data exchange between Oracle 10g and 8i databases We have an Oracle 8i database connected to other 8i databases. If we upgrade it to Oracle 10g but leave the others at 8i, will there be any problem with the data exchange?

Are Oracle 10g and VB 6.0 compatible? I need to do an upgrade from Oracle 8i to 10g. Currently, the 8i database interfaces with VB 6.0. I'm wondering whether 10g and VB 6.0 are compatible.

Impact of Oracle 8i to Oracle 10g migration on scripts We are going to migrate from Oracle 8i to Oracle 10g on Unix. Will the migration cause any impact on our Pro*C scripts and Unix shell scripts?

Have a question for an expert?

Please add a title for your question

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

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Please create a username to comment.

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

IT's technology experience problem gets HR tool

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Dig Deeper on Oracle database administration

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.