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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: