Database Upgrade Using Transportable Tablespaces: Oracle Database 10g Release 2

The TransporTable Tablespace (TTS) feature, introduced in Oracle8i, was originally released as a method to move a subset of one database into another, such as plugging parts of an OLTP database into a data warehouse. However, TTS may reduce database upgrade time by moving all user tablespaces from a database running an earlier software release to an empty target database running a current software release. This paper explains how to use the transportable tablespace feature in Oracle Database 10g Release 2 to upgrade a database from a previous Oracle Database 10g release. This paper complements the other MAA best practice papers that can be found on the Oracle Technology Network.