This is a significant upgrade path so there is really no "easy" way to do this. You cannot upgrade in place directly from Oracle 7 to 10gR2 so if you want to do the upgrade in one step, export and import is your best option. If you prefer to upgrade in place, according to the Oracle Database 10g Release 2 (10.2) Upgrade Guide, you will need to be at release 7.3.4, then you can upgrade to 18.104.22.168 and finally to Oracle 10gR2.
As mentioned, this is an enormous leap in database software technology so whatever option you choose, please ensure that you test the entire upgrade process from end to end in a non-production environment. There will likely be code changes to your applications, as well as some SQL tuning since the Oracle optimizer has changed dramatically from release 7.3.4 to 10.2. I'm assuming there is likely an operating system upgrade as part of this migration, too, so this will complicate the upgrade somewhat. If the database is not very large in physical size and you can take a reasonable outage to perform the upgrade, I would recommend using export and import. Export relevant schemas from the existing Oracle 7 database, and import them into the newly created Oracle 10gR2 database. You will still have to test thoroughly and likely make SQL and code changes, but at least this gets you to where you want to be in one big step, rather than two.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
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 ... Continue Reading
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." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.