Q

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.

I have Oracle 8i Release 8.1.6.0.0 enterprise 64 bit. The database size is quite small, say 100GB.

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?

Here are the steps for performing an 8i to 10g migration in Oracle:

  1. Install Oracle on your new server
  2. Create the new database using the Database Creation Assistant (DBCA)
  3. Precreate any tablespaces you will need.
  4. Import with FULL=Y. This will create your users and roles and everything else.
This was first published in October 2009

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close