Platform migration is the process of moving a database from one
operating-system platform to a different operating-system platform. There are two supported methods for doing this:
- Export the data from the database on the old
platform, create a new database on the new platform, and import the
data into the new database.
- Use the Transportable Database feature
You can expect a 50% or greater reduction in the time it takes
to complete a platform migration using Transportable Database when compared to traditional export/import methods.
Transportable Database 10gR2 was certified for the E-Business Suite last year. I'm pleased to announce that our Applications Platforms Group has certified this for the next database release -- Transportable Database 11gR1 -- with the E-Business Suite.
Database migration across platforms of the
same "endian" format (byte ordering) using the Transportable Database
(TDB) process is now certified with Oracle Database 11gR1 (126.96.36.199)
for Oracle E-Business Suite Releases 11i (188.8.131.52) and 12 (12.0.4 and
Suitable target platforms can be verified by querying
the view V$DB_TRANSPORTABLE_PLATFORM using sqlplus (connected as
sysdba) on the source platform:
SQL> select platform_name from v$db_transportable_platform;
the intended target platform appears in the output, Transportable
Database can then be used to migrate the database to this target.
Otherwise, an alternative such as export/import should be used instead.
Not the same as Cross-Platform Transportable Tablespaces (XTTS)
note that an alternative database technology known as Cross-Platform
Transportable Tablespaces (XTTS) to migrate data between platforms of
different endian formats is NOT yet certified with Oracle E-Business