Now we need to migrate to Oracle 10g R2. I have the 8i full dump taken using Oracle 8i. The new Oracle will be installed on Windows 2008 server x64 bit OS and we have Oracle 10gR2 standards 64 bit. I have not yet installed Oracle in the new server. Is there a link on step by step instruction to doing this migration from 8i to 10g you can give me?
- Install Oracle on your new server
- Create the new database using the Database Creation Assistant (DBCA)
- Precreate any tablespaces you will need.
- Import with FULL=Y. This will create your users and roles and everything else.
This was first published in October 2009