Oracle 12C database imported to 11 GB
The packages backed up from oracle 12c (expdp) are restored to 11 GB. We all know that there will be compatibility issues.
Sure enough, an error is returned:
ORA-39142: Version 4.1 (in the dump file forks. expdp) Not compatible
And so on.
Later, I learned that the version information should be specified during the backup in 12C. For example, I want to import the version information to the 11g Library (the specific version is 11.1.0.6.0 and you can see it by enabling sqlplus ), then version = 11.1.0.6.0
Statement:
Backup in 12C
expdp system/password@SID12c directory=dbbak dumpfile=20160321.expdp logfile=20160321.log schemas=leftfist version=11.1.0.6.0
Restore in 11g
impdp sys/password@SID11g directory=dbbak dumpfile=20160321.expdp logfile=20160321.log schemas=leftfist table_exists_action=replace
Of course, the creation of the backup file storage directory dbbak, the creation of tablespaces, users and other details are ignored. For details of this type, refer to the example.
Oracle 10 Gb backup and Restoration
References:
ORA-39142 IMPDP cross-version import data error Solution