The Transportable Tablespace (TTS) feature was introduced in Oracle 8i and the Cross-Platform Transportable Tablespace (XTTS) feature was introduced in Oracle 10g. Since it only involved the copy of the data files of the tablespace at the OS level and the copy (and maybe conversion) of the data files over the network, it was potentially […]
This example demonstrates how to transport a tablespace from a 10g ASM on Windows environment to 11g ASM on AIX environment using the DBMS_FILE_TRANSFER package. The source database on Windows is GENUA1 and the target database is a 11g RAC database RACDB1. Create the tablespace and the test object in the source database SQL> create […]
This note decribes in detail the steps used to migrate a 1.4 TB Oracle 10g database from an AIX platform to a Red Hat Linux platform with minimal downtime using the Cross Platform TTS technology introduced in Oracle 10g.