Hi All,
We are planning to migration one of our Oracle 9i databases from
HP-UX to AIX. What are our options? Upgrading our database to 10g in
this process will be a plus. Our database size if 2.5 TB, so
export/import is the least preferred option.

Couple of weeks back, I was in an Oracle presentation and I
tossed this question to the group. I got the following options from
them. Please suggest more options and add your comments.

1. 10g has a fast export and import feature. Can we use 9i's export
and 10g's fast import or do a fast export using 10g client from a 9i
database?

2. One guy the Oracle presentation claimed that he has done an RMAN
clone across platforms. If it works, our migration effort will be
reduced considerably.

3. Upgrade the database to 10g and use transportable tablespaces to
migrate data

Thanks,
Joe

"Joseph Silverius" <josil20 (AT) gmail (DOT) com> wrote

cant use data pump from 9i, just wont work im afraird, two very different
things.

upgrading to 10g and then using transportable tablespaces seems the best
option here
or upgrade to 10g and then use expdp and impdp - prefer TT myself