源端：ORACLE 版本号：12.2.0.1.0
导出：expdp system/sys#Yczbjt DIRECTORY=backup_mes DUMPFILE=SHYCBZMES20191013_full_UAT.dmpdp logfile=SHYCBZMES20191013_full_UAT.log full=y version =12.1.0.1.0
目标：ORACLE 版本号：12.1.0.1.0
导入： impdp system/sys#Yczbjt DIRECTORY=backup_mes dumpfile=SHYCBZMES20191013_full_UAT_V12-1.dmpdp logfile=SHYCBZMES20191013_full_UAT_V12-3.log schemas=messhycbz exclude=statistics
注意：
（1）如果目标端版本低于源端版本，需要源端版本导出时，加上版本号version =12.1.0.1.0；
否则会出现报错：
ORA-39342: Internal error - failed to import internal objects tagged with WMSYS due to ORA-20373: Unsupported version of Workspace manager detected. ORA-39083: Object type PROFILE:"DEFAULT" failed to create with error:
ORA-02376: invalid or redundant resource
（2）版本不一致情况，考虑使用system导出，system导入；
（3）考虑加上排除统计信息，exclude=statistics，统计信息容易出错
Processing object type DATABASE_EXPORT/STATISTICS/MARKER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.STATS_LOAD [MARKER]
ORA-30091: secondary translation table not loaded
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11014
文章评论