We are restoring a Clarity or Data Warehouse database dump (seed data) on Oracle and getting this error message:
ORA-39142: incompatible version number 5.1 in dump file
Trying to export schema/tables from higher Database version 126.96.36.199.0 and import to version 188.8.131.52.0, causing following error message.
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 5.1 in dump file “xxx.dmp”
Release : Any
Component : CA PPM INTEGRATIONS & INSTALLATIONS
This is an indication that the dump is being restored on a lower Oracle version. Please ensure you are on a supported Oracle version for your Clarity version, and you will be able to restore successfully.