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?

Improve this question

3 Answers 3

Reset to default
3

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

Improve this answer
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.

Improve this answer
1

You might want to look at this thread:

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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .