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
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.