My Oracle Support Banner

Compatibility Matrix for Export And Import Between Different Oracle Versions [Video] (Doc ID 132904.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Standard Edition - Version 7.3.2.0 to 12.2.0.1 [Release 7.3.2 to 12.2]
Oracle Database - Enterprise Edition - Version 7.3.2.0 to 12.2.0.1 [Release 7.3.2 to 12.2]
Oracle Database - Personal Edition - Version 7.3.2.0 to 12.2.0.1 [Release 7.3.2 to 12.2]
Information in this document applies to any platform.

Purpose

This article describes several issues related with the compatibility of the different versions of the Oracle Export and Import utilities.

Scope

The article is intended for users of the Oracle7, Oracle8, Oracle8i, Oracle9i, Oracle10g, Oracle11g and Oracle12c databases who wish to use the EXPORT and IMPORT utilities to export data from an Oracle database release x and import this data into an Oracle database release y. The article gives information which version of the utility to use when performing the export and import, and how to prepare the Oracle data dictionary before exporting the data.
For compatibility rules for the enhanced utilities Export Data Pump (expdp) and Import Data Pump (impdp) which were introduced in Oracle10g, see:
<Note:553337.1> "Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions"
For the transportable tablespaces export/import, see:
<Note:291024.1> "Compatibility and New Features when Transporting Tablespaces with Export and Import"
In the text below, the following terminology is used:

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!


In this Document
Purpose
Scope
Details
 1. Summary
 2. Introduction
 3. Data Dictionary Views
 4. Database Migration with a full database export/import
 5. Basic Compatibility
 6. Limitations
 7. Examples
 8. Possible error messages
 9. Remarks
 Additional Resources
References

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