What is the best way to migrate an Oracle 9i to Oracle 11g? I've started the migration already but it takes a long time, just to migrate 1 table. I am not sure what is wrong since I think, I haven't missed out anything. Can anybody here who have encountered the same issue before provide me an answer? Is a migration time of 4-7 hours normal? Thank you.
Hello Justin,
In upgrading 9i to 11g, there are so many things or ways to do and several option for transferring the data. You need to check my notes on Oracle upgrade gotchas because Oracle11g is very different from Oracle9i.
Ways to move the database from 9i to Oracle11g:
Export – Oracle data pump import will recognize an Oracle9i dmp file,
CTAS -Use "create table as select" over a database link to move specific tables.
Clone database – you can clone the Oracle9i database onto the 11g platform and upgrade it in-place, depending on your Operating systems.
When the migration is finished, please ensure that you will get the new features of Oracle 11g to understand what new features to employ.
I hope this information helps.
