Manual data migration from 9i to 10g

[divroro12]

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

[PAVB]

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?

[divroro12]

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.

[PAVB]

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.

[divroro12]

Export/Import is definitely not gonna work in this scenario.
Will try the second option...

[ixion]

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!