11gR2 Transportable Tablespaces Certified for EBS 11i

Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for Oracle E-Business Suite Release 11i ( with Oracle Database 11g Release 2.

Small endian to big endian platform migrations

Obtaining this patch

This migration process requires a "Controlled" patch delivered by the Oracle E-Business Suite Platform Engineering team, i.e. it requires a password obtainable from Oracle Support. We released the patch in this manner to gauge uptake, and help identify and monitor any customer issues due to the nature of this technology. In addition to the requirement for as the Release 11i version, TTS migration requires both the source machine and target machine databases to be 11gR2.

Does it meet your requirements?

Note that for migration across platforms of the same "endian" format, users are advised to use the Transportable Database (TDB) migration process instead for large databases. The "endian-ness" target platforms can be verified by querying the view V$DB_TRANSPORTABLE_PLATFORM using SQL*Plus (connected as sysdba) on the source platform:

SQL>select platform_name from v$db_transportable_platform;

If the intended target platform does not appear in the output, it means that it is of a different endian format from the source. Consequently. database migration will need to be performed via Transportable Tablespaces (for large databases) or export/import.

The use of Transportable Tablespaces can greatly speed up the migration of the data portion of the database. However, it does not affect metadata, which must still be migrated using export/import. We recommend that users initially perform a test migration on their database, using export/import with the 'metrics=y' parameter. This will help identify the relative amounts of data and metadata, and provide a basis for assessing likely gains in timing. In general, the larger the amount of data (compared to metadata), the greater the reduction in downtime that can be expected from using XTTS as a migration process.

Where can I find more information?

Related Articles


Thanks very much. We have been waiting for this.

We are now in track.


Posted by Chenthil Murugan on November 01, 2011 at 07:28 AM PDT #

Hi, Is this method certified for "Oracle E-Business Suite Release 11i ( with Oracle Database 11g Release 1" also ?

Posted by guest on February 06, 2012 at 01:36 PM PST #

Hi - no, it's not. It's only certified with 11gR2.

Posted by John Abraham on February 06, 2012 at 01:47 PM PST #

We used this technology and it was really cool, few pit falls but great...thanks for supporting this...


Posted by Chenthil Murugan on February 09, 2012 at 06:04 AM PST #


Glad that you found this feature useful. Your comment about pitfalls caught my eye. Can you provide more details, either publicly here, or via a private email? We'd be particularly interested in getting Service Request numbers for any issues that you might have encountered.


Posted by Steven Chan on February 09, 2012 at 10:04 AM PST #

John, Steven,

Are there any plans to certify XTTS against EBS 11i and Oracle Database 11g Release 1 also ? Given XTTS is certified against a non EBS 11i can you highlight the reasons why it isn't with EBS 11i ?



Posted by William Wong on June 11, 2012 at 02:18 AM PDT #

Hi - what happens if you do this at 11gR1 and no EBS patch is applied?

What does the patch do?

Thanks, James

Posted by guest on June 11, 2012 at 05:04 AM PDT #

hi Will, James -
There are no plans currently to certify 11gR1 XTTS with 11i - in addition to explicit testing and necessary fixes, we also provide an associated patch that contains all necessary scripts that should be run for the particular version of EBS and Database combination. While customers could conceivably go on their own using the DB only documentation, they may also uncover unforeseen issues for which code fixes would not be forthcoming due to the lack of certification.
Our recommendation would be to upgrade first to 11gR2 followed by the TTS migation (Note 1366265.1).

Posted by John Abraham on June 11, 2012 at 11:17 AM PDT #

Hi Steven,
We are starting to process of TTX between AIX to Linux on the DB tier.
I am working with note 1366265.1.

we have 1104 tablespace.
look like that the scripts from patch in the not cant handle that amount.

any recommendation ?

Posted by guest on March 25, 2014 at 08:19 AM PDT #

Hello guest -
Please file an Oracle Support Service Request (SR) with the exact error or limitation you're encountering, and we'll work through the issue you're seeing that way.

Posted by John Abraham on March 25, 2014 at 09:41 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« November 2015