Q
Problem solve Get help with specific problems with your technologies, process and projects.

Possible complications in migrating from 8.1.7 to 10g

What are the database-related issues that need to be taken care of while migrating from Oracle 8.1.7 to Oracle 10g? I want to know any specific things about packages or trigger declarations, default values, etc. that will get affected with this. Will we face any problems in compilation at all?

What are the database-related issues that need to be taken care of while migrating from Oracle 8.1.7 to Oracle 10g? I want to know any specific things about packages or trigger declarations, default values, etc. that will get affected with this. Will we face any problems in compilation at all?
This is a difficult question for me to answer because I have no information about your environment or applications. The one thing you want to make sure you do enough of is testing. You will want to test both the upgrade process, as well as perform functional testing via the application. There were some big changes made in Oracle 10g from Oracle8i so you may, in fact, encounter some code compilation issues. The best approach is to read about the new features in 10g, upgrade your database in a development environment (several times, if possible) and then ensure that your application support teams and business users test every process and function prior to attempting the upgrade in production.

For information on Oracle 10g's new features and upgrade methods, download the following documentation from Oracle Technology Network:

Oracle Database New Features Guide 10g Release 2 (10.2)

Oracle Database Upgrade Guide 10g Release 2 (10.2)

Dig Deeper on Oracle database export, import and migration

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close