Need help in migrating files in Oracle 9i to 11g

Asked By justin sy 300 points N/A Posted on - 04/13/2012

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.

• Status: Open
• Question Views: 1199
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Mark Amna 5 points N/A #104094

Need help in migrating files in Oracle 9i to 11g

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.

About Mark Amna

Questions
0

Answers
90

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 04/27/2012
• Question Category: Oracle Database