ORA-39358: Export dump file version 18.3.0.0.0 not compatible with target version 18.1.0.0.0

Hi,

Sometimes You can get ” ORA-39358: Export dump file version 18.3.0.0.0 not compatible with target version 18.1.0.0.0 ” during impdp operation.

 

Details of error are as follows.

Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39358: Export dump file version 18.3.0.0.0 not compatible with target version 18.1.0.0.0

 

 

Target database compatibility can not be lower than source database compatibility. If Target database compatibility is lower than source database compatibility, then you should use the version parameter and run export with version of target database compatibility.

 

Check Source ( export ) compatibility as follows.

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 18.3.0.0.0
noncdb_compatible boolean FALSE
SQL>

 

and Check Target ( import ) compatibility as follows.

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 18.0.0
noncdb_compatible boolean FALSE
SQL>

 

To solve this error, you may modify target compatibility from 18.0.0 to 18.3.0 as follows.

SQL> alter system set compatible='18.3.0' scope=spfile;

System altered.

SQL>

 

And restart database then try to run same import command again.

 

Or You can use the version parameter in the export.

 

version=18.0

 

You can change this version value according to your database version.

 

Target database compatibility can not be lower than source database compatibility. If Target database compatibility is lower than source database compatibility, then you should use the version parameter and run export with version of target database compatibility.

 

To solve this error, run the export again using the version parameter as follows.

 expdp \"/ as sysdba\" directory=PUMP schemas=MSD dumpfile=MSD_NEW%U.dmp version=18.0 logfile=MSD_NEW.log parallel=32 cluster=n exclude=statistics

 

Once export is completed, you can run the import in the source, it will work fine.

Do you want to learn more details about Oracle Datapump, then read the following articles.

https://ittutorial.org/oracle-data-pump-export-import-4/

 

 789 views last month,  1 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Do NOT follow this link or you will be banned from the site!