Oracle Database Transportable Technologies
Oracle's Transportable technologies include Transportable Database and Transportable Tablespaces, which enable tablespace and database migration and upgrade, as well as efficiently solving a variety of data moving use cases.
Using Transportable Technologies for Database Migration and Database Upgrade
The Transportable Database feature enables users to migrate an Oracle Database (10g Release 2 and higher) to another platform that has the same endian format. Notice that for some platform combinations, Oracle Data Guard is the preferred solution for platform migrations. The prerequisites and procedure are detailed in the MAA whitepaper Platform Migration Using Transportable Database Oracle Database 11g and 10g Release 2 (PDF).
The Transportable Tablespaces feature allows users to quickly move a user tablespace across Oracle databases. An important use of Transportable Tablespaces is to support the migration a of database between platforms that have a different endian format. The prerequisites and procedures for migration are detailed in the MAA whitepaper Platform Migration Using Transportable Tablespaces (PDF).
Transportable Tablespaces also supports one of the methods for upgrading a database. The use cases and their procedures, as well as pointers to other methods, are covered in the MAA whitepaper Database Upgrade Using Transportable Tablespaces: Oracle Database 11g Release 1 (PDF).
Hint: query the
V$TRANSPORTABLE_PLATFORM view to see the platforms that are supported, and to determine their platform IDs and their endian format.
Other Uses of Transportable Tablespaces
Moving data using Transportable Tablespaces can be much faster than performing either an export/import or unload/load of the same data. This is because transporting a tablespace only requires the copying of datafiles and importing the tablespace structural information. You can also use Transportable Tablespaces to move both table and index data, thereby avoiding the index rebuilds you would have to perform when importing or loading table data. Transportable Tablespaces can also be used to facilitate a database upgrade.
The Transportable Tablespaces feature is also useful for copying multiple read-only versions of a tablespace on multiple databases and for archiving historical data.
Because Transportable Tablespaces works across platforms, you can also use this feature to:
|Documentation||Technical Whitepapers (PDF)|
|High Availability Case Studies|