The Oracle 10g Upgrade Guide (from the base documentation) is your best source for information. Given that you are changing platforms, you have two options:
- Upgrade the database to 10g on the Windows platform (which will require two upgrades really since you can't upgrade from 8.1.6 directly to 10g). Once you're running 10g on Windows, you can use the cross-platform transportable tablespaces feature to migrate the database to Linux. This is will be the longest method and require the most intermediate steps since you will also probably need to upgrade Windows because 10g isn't supported on Windows NT.
- Install 10g on Linux and create a new database. Export the entire database from your existing environment using the export utility and then import that into the new database on Linux. If you have a relatively small database, this method will be fast and not require any intermediate steps.
Most importantly, test everything on the new platform before migrating your application to use the new platform.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Dan Norris
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.