My Oracle Support Banner

Compatibility and New Features when Transporting Tablespaces with Export and Import (Doc ID 291024.1)

Last updated on SEPTEMBER 11, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 to 10.2.0.5 [Release 8.1.7 to 10.2]
Oracle Database - Personal Edition - Version 8.1.7.0 to 10.2.0.5 [Release 8.1.7 to 10.2]
Oracle Database - Standard Edition - Version 8.1.7.0 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.

Purpose

This article describes the compatibility and the features and limitations of Transportable Tablespaces Export and Import.

Scope

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

NOTE:
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:
http://docs.oracle.com/database/121/SUTIL/GUID-901CBBE0-65FB-439E-942D-F2038C18BCD2.htm

 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.