Manage

Difference between migration and upgrade

I believe this is a not a good response to the following question. The manual does not specifically or categorically answer the question proposed. Migrate/export (duplicate copy) is really different from the concept upgrade (replace Oracle version).

Brian Peasland

Published: 27 Feb 2007

I believe this is a not a good response to the following question. The manual does not specifically or categorically answer the question proposed. Migrate/export (duplicate copy) is really different from the concept upgrade (replace Oracle version). No offense, but could you make a real attempt to answer the question?

QUESTION POSED ON: 15 December 2006

I have to migrate or export data from Oracle 8i to Oracle 10g. The size of the data would be approximately 80GB. So please guide me if there are any front-end tools to do so or any other technology that can be used. And also, it would be helpful if someone could give me an estimate of the time required to migrate this.

EXPERT RESPONSE

Before upgrading any database, please read the Upgrade Guide. Oracle has documented all of your options and included step-by-step instuctions.

I do not think you will be happy with my answer, because it refers you back to this document. From this document, you can see the four options to upgrading from Oracle 8i to Oracle 10g. Specifically look at this section. As you can see, your four options are to use the DBUA, manual upgrade, export/import, or to copy the data. There are no third-party tools involved here as these options are the only ones supported by Oracle. This section even gives instructions on how to use these tools. This one even gives guidelines to preparing for your upgrade.

Rather than rewrite the documentation set, I point people to the documentation. I do this for two reasons. One, the answer is already provided and I should not have to reinvent the wheel. Two, it has been my experience that people are afraid of the documentation and my links to the location is a start to getting them familiar with the information presented there. My goal here is to teach people how to solve their own problems rather than waiting for someone else to do the work for them.

Dig Deeper on Oracle database backup and recovery

How to perform a Big to Little Endian conversion in Oracle 8i

How to perform an Oracle 8i to 10g migration

Solving common Oracle error codes guide

Migrating to Oracle: Expert Secrets to Migrate from SQL Server and MySQL

Related Q&A from Brian Peasland

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.