在做几个环境的数据整合,分别有oracle11g和12.1的库导入到12.2.0.1环境,发现导入的时候报错如下:
ORA-39097: Data Pump job encountered unexpected error -56935
ORA-39065: unexpected master process exception in DISPATCH
ORA-56935: existing datapump jobs are using a different version of time zone data file
算是oracle 的一个bug,详情参考doc1307959.1
解决办法:
查看视图:
SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE ‘DST_%’
ORDER BY PROPERTY_NAME;
这个DST_UPGRADE_STATE值要为NONE,如果是其它类似datapump(3)之类的,
则要多次执行如下操作:
ALTER SESSION SET EVENTS '30090 TRACE NAME CONTEXT FOREVER, LEVEL 32';
exec dbms_dst.unload_secondary;
直到DST_UPGRADE_STATE为NONE,问题则解决。