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?
|
feedback
|
migrated from stackoverflow.com Jan 8 '11 at 10:26
This question came from our site for professional and enthusiast programmers.
|
There are choices here. Check out the Oracle Documentation Upgrade Guide for more info. | |||
|
feedback
|
|
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. | |||
|
feedback
|
|
You might want to look at this thread: Porting an application from Oracle 9 to Oracle 11 - gottchas? | |||
|
feedback
|
