ORA-39142: incompatible version number string in dump file “string”

文档解释

ORA-39142: incompatible version number string in dump file “string”

Cause: A dump file was specified for an import operation whose version number is incompatible with the dump file version of the Data Pump product currently running on the system. Usually this message indicates that the dump file was produced by a newer version of the Data Pump export utility.

Action: Import this dump file using the Data Pump import utility with the same version as the export which created the file.

ORA-39142错误表示导入的数据库的版本号不匹配。

官方解释

常见案例

一般处理方法及步骤

1. 首先需要检查源数据库的版本与目标数据库的版本是否兼容。

2. 如果不兼容，可以尝试通过data pump工具或imp/exp工具导入数据。

3. 尝试将源数据库升级或者降低目标数据库的版本号，使两个数据库的版本号兼容。

4. 通过全新安装的源数据库产生更兼容的dump文件，再次尝试导入数据。