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?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
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: