Oracle migration issues

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

    Accepted 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

    LVL 73

    Expert Comment

    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 47

    Expert Comment

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

    Expert Comment


    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:


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now