-
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...
-
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.
-
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.
-
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.
-
Export/Import is definitely not gonna work in this scenario.
Will try the second option...
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|