Unanswered: Oracle Streams for database migration?
We have a 600GB database to be upgraded from Oracle 9i on HP-UX to Oracle 10g on RH-Linux. In-place upgrade from 9i to 10g on HP-UX cannot be considered and hence we cannot use transportable tablespaces/data pump.
We are left to use parallel exp/imp sessions for data migration as downtime is limited to 10 hours.
Would it be feasible to use Oracle Streams from 9i to 10g across platforms for this migration? Please suggest.