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

Related Documents
http://arjudba.blogspot.com/2009/02/important-guideline-about-data-pump.html
http://arjudba.blogspot.com/2009/02/how-to-do-data-pump-import-from-higher.html
http://arjudba.blogspot.com/2008/04/data-pump-exportimport-how-we-can-do-it.html
http://arjudba.blogspot.com/2009/02/ude-00018-data-pump-client-is.html
http://arjudba.blogspot.com/2008/04/exportimport-datapump-parameter-query.html
http://arjudba.blogspot.com/2008/04/improve-data-pump-performance.html
http://arjudba.blogspot.com/2009/02/how-to-take-data-pump-export-on-another.html
http://arjudba.blogspot.com/2008/04/datapump-parameters-include-and-exclude.html