My Oracle Support Banner

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

Last updated on SEPTEMBER 14, 2024

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.