Thursday , March 28 2024

ORA-39142: incompatible version number 5.1

This error is received when trying to import a Data Pump export of the 12c r2 database to a lower version.

The error content is as follows.

In order not to receive this error, the database version to be imported must be specified with the VERSION parameter in the expdp command.

Below are the version values ​​of the databases.

  • VERSION=10.1 for 10.1.0.x
  • VERSION=10.2 for 10.2.0.x
  • VERSION=11.1 for 11.1.0.x
  • VERSION=11.2 for 11.2.0.x
  • VERSION=12.1 for 12.1.0.x

Example

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories