Home / server / Questions / 220082
Accepted
AJM
Asked: 2011-01-07 06:16:36 +0800 CST

Oracle Move from 9 to 11

  • 772

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?

oracle oracle-11g oracle9i

3 Answers

  1. Best Answer

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

    • 3

  2. 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
    • 1