Monthly Archives: April 2015

Using Transportable Tablespaces to Migrate Oracle E-Business Suite Release 12.0 or 12.1 Using Oracle Database 12c Release 1 Enterprise Edition

30 Thursday Apr 2015

Posted by in Uncategorized

≈ Leave a comment


This page describes the process of migrating an existing Oracle Applications Release 12.0 or 12.1 database instance using the Cross Platform Transportable Tablespaces (XTTS) feature of Oracle Database 12c Release 1.

Transportable Tablespaces is a feature that provides a faster means to move bulk data from one database to another, independent of the operating system of the source and target. This cross-platform support of this feature provides improved functionality in distributing data and database migration specifically across platforms of different endian (byte-ordering) formats. For details on this feature, please refer to the section ‘Transporting Tablespaces Between Databases’ in Chapter 15 (‘Transporting Data’) of the Oracle Database Administrator’s Guide, 12c Release 1 (12.1).

Known Issues and Limitations of XTTS

  1. Built-in Limitations 
    Built-in limitations are documented in the Oracle Database Administrator’s Guide, 12c Release 1 (12.1). One important limitation outlined in this document that is relevant for EBS is that the source and target databases must have the same character set and national character set.
  2. Column Encryption Using TDE 
    Transportable Tablespaces migration is not supported for tables that have columns encrypted using the Transparent Data Encryption (TDE) functionality of Oracle Database 12c (see My Oracle Support Document 732764.1). Tables that have encrypted columns must be de-crypted prior to following the transportable tablespaces migration and then encrypted in the target database after migration.
  3. Mixing RDBMS and EBS Schemas in the same Tablespace 
    The use of RDBMS and EBS Schemas in the same tablespace is not supported as tablespaces with RDBMS schemas are disregarded in the creation of the transportable set. It is recommended that RDBMS schemas (such as CTXSYS) be in separate tablespaces (for example, SYSAUX).
  4. Cross Platform Incremental Backup
    Cross Platform Incremental Backup is only certified to work with RDBMS 12.1.0 source.
  5. Full Transportable Export/Import
    Full Transportable Export/Import is only certified to work with RDBMS 12.1.0 source.

The most current version of this document is Note 1945814.1 on My Oracle Support.