Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 









Transportable Tablespace

Oracle RAC Cluster Tips by Burleson Consulting

This is an excerpt from the bestselling book Oracle Grid & Real Application Clusters.  To get immediate access to the code depot of working RAC scripts, buy it directly from the publisher and save more than 30%.

When it is not feasible to consolidate the database resources, database systems tend to grow in different geographical locations and in different departments and often in different operating systems or platforms. In such cases, the feature of Oracle Transportable Tablespace offers an efficient way of sharing large subsets of data and then sharing the processing on this data on different hardware resources. This also is a key requirement for effective grid-enabling architecture.

Transportable Tablespace gives the grid users a very fast and efficient mechanism to move large data from one database system to another. Another feature that is particularly useful for large enterprises is the facility of mounting read-only tablespace by two or more databases.

With 10g release, it becomes possible to move the transportable tablespace across different platforms or operating systems. Another new feature is the provision of big tablespaces, which support ultra-large tablespaces to store the objects.

New Cross-Platform Transportable Tablespace

A transportable tablespace allows the quick movements of a subset of an Oracle database from one Oracle database to another.  However, in the previous release of Oracle server, it was only possible to move a tablespace across Oracle databases within the same platform. Oracle 10g is going one step further by allowing the movement of tablespace across different platforms. This feature becomes particularly significant in the Grid framework where many different operating systems coexist and conduct data movements and data sharing.

The limitation requiring transportable tablespaces to be transferred to the same operating system has been removed. However, to transport tablespaces across different platforms, both the source and target databases must be at least on Oracle Database 10g, be on at least version 10.0.1, and have the compatible initialization parameter set to 10.0. Using the new cross-platform transportable tablespace method to move data is more efficient than the traditional method of export and import.

Oracle Database 10g supports many platforms for transportable tablespace. A new data dictionary view, v$transportable_platform, lists all the supported platforms, along with platform ID and endian format.

The v$database data dictionary view also adds two columns, platform ID and platform name:

SQL> select name, platform_id,platform_name from v$database;

-------   -----------     -----------------------
GRID                2     Solaris[tm] OE (64-bit)

For example, it is not necessary to convert the data file to transport a tablespace from an AIX-based platform to a Sun platform, since both platforms use a big endian. However, to transport a tablespace from a Sun Platform (big endian) to a Linux Platform (little endian), the CONVERT command in the RMAN utility should be used to convert the byte ordering.  This can be done on either the source platform or the target platform.

This is an excerpt from the bestselling book Oracle Grid & Real Application Clusters, Rampant TechPress, by Mike Ault and Madhu Tumma.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.


Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational