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