TTS - from 9i to 10g
Hello
we have a 9.2.0.7 RAC database running on 32 bit windows
we are in the process of migrating this to a newer hardware infra structure and 11g RAC on Windows X64
We cannot use transportable tablespaces as source database is 9i 32 bit windows and target is 64 bit
At this time, export / import (schema level) seems to be the only choice but
based on the size of the tables, the export will take about 16 hours
we have not taken into equation the time to transfer the exp files over to the new server and run import
This would mean a downtime of about 24 hours which from a business perspective seems very difficult to get
we have a 9.2.0.7 RAC database running on 32 bit windows
we are in the process of migrating this to a newer hardware infra structure and 11g RAC on Windows X64
We cannot use transportable tablespaces as source database is 9i 32 bit windows and target is 64 bit
At this time, export / import (schema level) seems to be the only choice but
based on the size of the tables, the export will take about 16 hours
we have not taken into equation the time to transfer the exp files over to the new server and run import
This would mean a downtime of about 24 hours which from a business perspective seems very difficult to get
0