Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

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

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

3 Answers 3

up vote 3 down vote accepted

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

share|improve this answer

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

You might want to look at this thread:

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.