Now we need to migrate to Oracle 10g R2. I have the 8i full dump taken using Oracle 8i. The new Oracle will be...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.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.