Oracle Move from 9 to 11

Question

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?

score 3 · Accepted Answer · answered Jan 06 '11 at 14:25

3

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

answered Jan 06 '11 at 14:25

Adam Hawkes

251
1
2

score 1 · Answer 2 · answered Jan 06 '11 at 14:52

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.

score 1 · Answer 3 · edited May 23 '17 at 12:41

1

You might want to look at this thread:

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

edited May 23 '17 at 12:41

Community

1

answered Jan 06 '11 at 15:09

cagcowboy

1,072
1
14
21

Oracle Move from 9 to 11

3 Answers3