Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.