CODEWITHSUNDEEP
databaseoracle-databaseplsqloracle12c
jrpsbadmn
jrpsbadmn

Reputation: 55

ORA-39358: Export dump file version 12.2.0 not compatible with target version 12.1.0.2.0

I have upgraded my ORACLE local from 12.1.0.2.0 to 12.2.0.1.0, and I have dump exported from 12.2.0.1.0, and I am importing that dump by impdp command, but it showing old target ORACLE version with following error

ORA-39358: Export dump file version 12.2.0 not compatible with target version 12.1.0.2.0

I have tried to execute impdp command as administrator, It showing the correct database connected to, but the issue is same

log file of impdp:

;;; 
Import: Release 12.2.0.1.0 - Production on Wed Jun 12 15:41:17 2019

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Master table "NEW_DB"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
ORA-39358: Export dump file version 12.2.0 not compatible with target version 12.1.0.2.0
Job "NEW_DB"."SYS_IMPORT_FULL_01" successfully completed at Wed Jun 12 15:41:26 2019 elapsed 0 00:00:07
Job "NEW_DB"."SYS_IMPORT_FULL_01" successfully completed at Wed Jun 12 15:41:27 2019 elapsed 0 00:00:08

Upvotes: 4

Views: 15269

Answers (1)

Rene
Rene

Reputation: 10541

Start you export with parameter VERSION=12.1. This will make the export compatible with your target 12.1 database.

expdp system@std12c VERSION=12.1 schemas=...

You might run into some problems if your source database uses options not yet available in your target database. For example:

Warning: Oracle Data Pump is exporting from a database that supports long identifiers to a version that does not support long identifiers

Upvotes: 3

Related Questions