Learn how to a build a cloud-first strategyRegister Now


Oracle migration issues

Posted on 2011-10-13
Medium Priority
Last Modified: 2013-11-11
What are the common oracle migration issues ?
Question by:hussainkhan22
LVL 23

Accepted Solution

OP_Zaharin earned 2000 total points
ID: 36966431
- here is a few issue:
> database character-set differences
> targeted user schema and tablespace different from the source
> table normalization issue, whereby source table and targeted table has different name and structure
> targeted column have different datatype and size compared to the source
> data cleanup
> duplicate data
> tablespace size
> etc

LVL 74

Expert Comment

ID: 36966535
that's a huge topic, depends on what you are migrating

biggest issue are compatibility -  

are you moving to supported platform?
are you moving to same structure (will datafiles need renamed)
is os config the same?
is the new machine reachable by all clients?

downtime - can you take an outage or do you need to migrate live system with switchover?

licensing - Oracle licenses per core and migrating to a new machine may change what you owe
LVL 48

Expert Comment

ID: 36967169
The biggest issue are the volumes of the data.

If the volume of the data is small (or you can many applications and can migrate application after application) you can use Data Pump (export/import) approach.

In the oposite case (big volume) transportable tablespaces is one of the solutions.

Expert Comment

ID: 36967246

I'd recommend you to read the Oracle Documentation that has some valuable input about the preupgrade and post-upgrade considerations. Most of these items are also valid for the migration. Of course if you want more precise help you should at least provide some basic information about the migration that you are planning - source platform, version of the DB, size of the DB, destination platform, version etc.

For 11.2 upgrade considerations please check:



Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This article will show you step-by-step instructions to build your own NTP CentOS server.  The network diagram shows the best practice to setup the NTP server farm for redundancy.  This article also serves as your NTP server documentation.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month21 days, 1 hour left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question