• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 504
  • Last Modified:

Oracle migration issues

What are the common oracle migration issues ?
1 Solution
- 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

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
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.

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:


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now