Compatibility Table of Oracle Data Pump with oracle database versions

In this post I am going to make a table that will cover all compatibility aspects regarding oracle data pump up to release Oracle 11g. At first let's have a look at data pump dump file set versions. When your use data pump export client a dump file is created. Dump file set version is dependent on database compatibility. Below is the chart.

A)Database Compatibility and Dump file Set Version.































Database compatibility Setting Dump file set version Can be imported into 10.1.x Can be imported into 10.2.x Can be imported into 11.1.x
10.1.x 0.1 Yes Yes Yes
10.2.x 1.1 No Yes Yes
11.1.x 2.1 No No Yes


B)Overview of using VERSION parameter while data pump export
As you might know you need to use VERSION parameter while doing data pump export if you decide to import into lower compatible database from the higher compatible database parameter setting.































Source Database compatibility Setting Need to import to compatible setting 9.2.0.x Need to import to compatible setting 10.1.0.x Need to import to compatible setting 10.2.0.x Need to import to compatible setting 11.1.0.x
10.1.0.x VERSION=9.2 N/A N/A N/A
10.2.0.x VERSION=9.2 VERSION=10.1 N/A N/A
11.1.0.x VERSION=9.2 VERSION=10.1 VERSION=10.2 N/A


C)Overview of data pump Client/Server Compatibility Can you connect with your 11.1.0.6 client expdp/impdp into 10g database version? This part will cover those things.



















expdp and impdp client version Connecting to database 10gR1(10.1.x) Connecting to database 10gR2(10.2.x) Connecting to database 11gR1(11.1.x)
10.1.0.x Supported Supported Supported
10.2.0.x Not Supported Supported Supported
11.1.0.x Not Supported Not Supported Supported