2

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?

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

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

3

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

1

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.

1

You might want to look at this thread:

https://stackoverflow.com/questions/515532/porting-an-application-from-oracle-9-to-oracle-11-gottchas

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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