My Oracle Support Banner

Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions (Doc ID 553337.1)

Last updated on MARCH 31, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Enterprise Manager for Oracle Database - Version and later
Exadata X4-2 Full Rack - Version All Versions to All Versions [Release All Releases]
Oracle Database - Personal Edition - Version to [Release 10.1 to 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.


This article describes issues related to the compatibility of the different versions of the Oracle Export Data Pump and Import Data Pump utilities.


The article is intended for users of the Oracle10g and Oracle11g databases who wish to use Export Data Pump (expdp) and Import Data Pump (impdp) to export data from an Oracle database release x and import this data into an Oracle database release y. The article gives information how to create an Export Data Pump dumpfile that can be imported into a higher or lower release database, and how the compatibility applies when Data Pump is used over a database link.
For the compatibility of the original export and import clients (exp resp. imp), see:
<Note:132904.1> "Compatibility Matrix for Export & Import 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: 


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
 1. Summary
 2. Introduction
 3. Basic Data Pump Compatibility
 4. Export Data Pump Compatibility
 5. Import Data Pump Compatibility
 6. Database Migration with a Full Database Data Pump Export/Import
 7. Examples
 8. Possible Error Messages
 9. Known Defects
 @ 10. For Support: Enhancement Requests.
 Additional Resources

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