Compatibility and New Features when Transporting Tablespaces with Export and Import
(Doc ID 291024.1)
Last updated on MAY 11, 2021
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 10.2.0.5 [Release 8.1.7 to 10.2]
Oracle Database - Personal Edition - Version 126.96.36.199 to 10.2.0.5 [Release 8.1.7 to 10.2]
Oracle Database - Standard Edition - Version 188.8.131.52 to 10.2.0.5 [Release 8.1.7 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
This article describes the compatibility and the features and limitations of Transportable Tablespaces Export and Import.
The article is intended for users of the Oracle8i, Oracle9i, and Oracle10g databases who wish to transport tablespaces between databases. The article gives information which version of the export and import utility to use, and gives a summary of the features that were introduced in different versions.
For more recent versions of Oracle, please refer to:
<Note 1454872.1> - Transportable Tablespace (TTS) Restrictions and Limitations: Details, Reference, and Version Where Applicable
Original Export is desupported for general use as of Oracle Database 11g. The only supported use of original Export in Oracle Database 11g is backward migration of XMLType data to Oracle Database 10g release 2 (10.2) or earlier. Therefore, Oracle recommends that you use the new Data Pump Export and Import utilities
Please refer to:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!