Upgrade from 8.1.7.4 to 11.1.0.7 and platform migration Solaris 8 to AIX 53
hi people,
I'm currently performing a datawarehouse database upgrade, and migrating from Solaris 8, Oracle 8.1.7.4 (32 bit)
to a new server on IBM AIX 5.3, on Oracle 11.1.0.7
My initial upgrade path is as follows:
1- upgrade to 10.2.0.4 (64-bit) on Solaris 8
2- use transportable tablespace feature to migrate form Solaris to AIX
3- create 10.2.0.4 database on AIX, import tablespaces from Solaris 10.2.0.4
4- upgrade AIX, 10.2.0.4 database to 11.1.0.7
question: is step 3 necessary? is it possible to import TTS into 11.1.0.7 directly?
Another option would be to use expdp (datapump), but this is as I expect a very time consuming process..
Appreciate your thoughts and feedback
Steven