Unfortunately a direct upgrade (using dbua or similar) from 8i to 11g is not supported. So there are only two ways for an upgrade:
a) export - import
b) upgrade your database to a supported version (e.g. 126.96.36.199) and upgrade that one to 11g.
To be honest I would go with a!
i would want use the datapump export
That doesn't work as data pump export is available since 10g only.
But guess what you might want to try it using a database link from the 11g database (impdp with NETWORK_LINK).
1 person found this helpful
i must use currently
But if i am 10g i using data pump, with out forget it'snt on the same OS version
you can only import with data pump if you had exported the content with data pump as well. So you must use the "old" import with 11g as well.
I am doing something very similar as yourself. Moving from 9i (188.8.131.52) (Solaris 9) to 11g (184.108.40.206) (SUSE Linux 11).
The DB his 24/7 system ! On SUN servers where warranty will expiry in June.
There are 2 parts to this:
9i (220.127.116.11.0) - patchset 18.104.22.168.0 (direct) + 9373986 (patch)(DB capture) - same server. This allows direct upgrade to 10g. (10.2.0.4.0) using dbua.
(10g-dbua wizard has bug - create full rman backup yourself plus do not move files, as part of dbua) (quick)
10g (10.2.0.4.0) to 11g (22.214.171.124) - use TTS (http://msutic.blogspot.co.uk/2009/11/cross-platform-migration-large-oracle.html)
DB replay + SQL Performance Analyzer. -part of Real Application Testing.
9i to 11gr2 has plenty of pitfalls - e.g. running of queries.
Upgrade itself his tricky but, this will not guarantee the success
Very good paper 'Upgrading from Oracle 9i to Oracle Database 11g: A real World Customer Experience'
The client has Dataguard Standby 9i Database also.
I need to test Dataguard on initial patchset + patch to 126.96.36.199.
what version of 8 are you using plus what OS ?
what destination of 11g plus os ?