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.
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.