DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Manual data migration from 9i to 10g

  1. #1
    Join Date
    Nov 2006
    Posts
    158

    Manual data migration from 9i to 10g

    Hi,

    I'm trying to migrate data from a 9i database to a 10g database. How do i carry out manual data migration for a 1.5 terabyte database?

    Thanks in advance for your help...

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Two questions...

    1- Are you upgrading/migrating an Ora9i database into an Ora10g one or are you just happen to move 1.5T from one to the other?

    2- What's your storage subsystem? do you have the data in an EMC alike system?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Nov 2006
    Posts
    158
    1. Iam just moving the data, not upgrading

    2. The data is stored on severall different hard drives on the same machive housing the ora 9i databse.

    The newly installed 10g database will run on the same machine along with the 9i database.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Well... as far as I can see you have two ways to go.

    1- Export/Import which is gonna be a lot of fun having 1.5T to move.
    Install Ora10g
    Export/Compress-on-the-fly table by table from Ora9i
    Uncompress/Import-on-the-fly table by table into Ora10g
    You are done

    2- Do not migrate, upgrade in a secondary place.
    Shutdown your Ora9i database
    Make an exact copy of all your datafiles in a different location
    Create a new Ora9i database with your clonned datafiles
    Install Ora10g
    Upgrade in place your newly cloned Ora9i into Ora10g

    Hope this helps.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Nov 2006
    Posts
    158
    Export/Import is definitely not gonna work in this scenario.
    Will try the second option...

  6. #6
    Join Date
    Jun 2006
    Posts
    259
    The upgrade to 10g will definately work:

    Here is another option if you would like to get a "fresh" start and re-org you data.
    1. Create your new 10g Database.
    2. IxUnload data from your existing 9i.
    3. Create your tables/schema (exp/imp without rows.)
    4. use sqlldr direct path!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width