How to perform an Oracle 8i to 10g migration
Oracle expert Brian Peasland explains how to perform an Oracle 8i to 10g migration when moving to Oracle 10g R2 with these step by step migration tips.
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.