I have an oracle 9 database. There is a requirement to move this to Oracle 11.
What is the best way to achieve this. Is it enough to export the database on 9 and import it again on 11 or is there an upgrade process that can be gone through?
3 Answers
There are choices here. Check out the Oracle Documentation Upgrade Guide for more info.
How big is your data and how many schemas? Doing the export/import can be a lot faster for smaller databases and gives you a chance to cleanup old users and re-organize tablespaces. It's not very practical for a large database like an E-Business Suite install although I had to do that once because I was going from big-endian to little-endian hardware.
You might want to look at this thread:
