ITPub博客

首页 > 数据库 > Oracle > ORA-39142: incompatible version number 5.1 in dump file

ORA-39142: incompatible version number 5.1 in dump file

Oracle 作者:hadba 时间:2017-12-09 19:52:52 0 删除 编辑

Error:  ORA-39142: incompatible version number 5.1 in dump file.

I did get this error while I was importing a schema.

I did export a schema from Oracle Database 12.2.x and trying to import it to Oracle Database 12.2.x (version mismatch)

Solution: User “Version” option while exporting from 12.2.x as below

expdp system/manager schemas=CISSCHEMA dumpfile=CIS_Dump.dmp logfile=CIS.log directory=DATA_PUMP_DIR Version=12.1

Once it is done, import it to 12.1.x version of database:

impdp system/manager schemas=CISSCHEMA dumpfile=CIS_Dump.dmp logfile=CIS.log directory=DATA_PUMP_DIR

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26664718/viewspace-2148486/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-02

  • 博文量
    80
  • 访问量
    96353