Data Engineering Associate Manager
Trivadis - Part of Accenture
Transportable Tablespaces (TTS) exist since Oracle 8i and are a method to exchange data between databases in an efficient way. With every new release, the capabilities were enhanced, for example, Cross-platform TTS in Oracle 10g or Restore Foreign Tablespace/Datafile in Oracle 12c. In the last few months, I was involved in a customer project where the main goal was to upgrade/migrate existing Oracle 11gR2 databases to 19c (including the switch to the CDB architecture). For a lot of databases, the TTS approach was used. This presentation summarizes the experiences gathered with the TTS procedure including all its ups and downs. After an introduction to TTS itself, different methods of copying the data files are presented – for example, DBMS_FILE_TRANSFER or Foreign Tablespace/Datafile Restore with RMAN. The next part of the presentation covers pitfalls and challenges with the actual data migration. New features and enhancements introduced with 19c and 21c are also part of the presentation.