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).
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.
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.