Take the 2-minute tour ×

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?

share|improve this question
add comment

migrated from stackoverflow.com Jan 8 '11 at 10:26

This question came from our site for professional and enthusiast programmers.

3 Answers

up vote 3 down vote accepted

There are choices here. Check out the Oracle Documentation Upgrade Guide for more info.

share|improve this answer
add comment

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.

share|improve this answer
add comment

You might want to look at this thread:

Porting an application from Oracle 9 to Oracle 11 - gottchas?

share|improve this answer
add comment

Your Answer


