My Oracle Support Banner

Examples Using DataPump VERSION Parameter And Its Relationship To Database COMPATIBLE Parameter (Doc ID 864582.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 27-MAR-2013***

Purpose

This article shows by example how setting of data pump VERSION parameter and database COMPATIBLE parameter affect the data pump export and import.

Scope

This article is intended to help users better understand how setting VERSION parameter be used.
Detailed examples with different settings of VERSION and COMPATIBLE are given that demonstrate how these parameters can affect data pump export/import.

For a detailed discussion of data pump compatibility see
<Note 553337.1> Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions

Here are basic definitions of the VERSION parameter for both export and import.

Export

Specifies the version of database objects to be exported. The VERSION parameter simply allows you to identify the version of the objects being exported.
It also defines the dumpfile compatibility.



Import

Specifies the version of database objects to be imported. The VERSION parameter simply allows you to identify the version of the objects being imported.
It does NOT mean you can specify VERSION equal to a lower database version to import a higher level dumpfile. For example, you cannot specify VERSION=10.1 to import a dumpfile that is version 11.1.

 

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
References

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