ORA-56935: 現有資料泵作業正在使用其他版本的時區資料檔案

將一個11.2.0.1的資料泵匯出檔案匯入12.1.0.2版本時，出現如下錯誤
連線到: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Produc
tion
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions
ORA-39006: 內部錯誤
ORA-39065: DISPATCH 中出現意外的主程式異常錯誤
ORA-56935: 現有資料泵作業正在使用其他版本的時區資料檔案

ORA-39097: 資料泵作業出現意外的錯誤 -56935

搜尋了半天，找到了如下解決方案

UNCATEGORIZED
impdp ORA-39097 ORA-39065 ORA-56935
MAY 12, 2015 ARCSDEGEO3 COMMENTS
While performing an import, I faced the below error:


ORA-39097: Data Pump job encountered unexpected error 
ORA-39065: unexpected master process exception in DISPATCH
ORA-56935: existing datapump jobs are using a different version of time zone data file


Solution:


Check the value of  DST_UPGRADE_STATE by the following query:


SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE ‘DST_%’
ORDER BY PROPERTY_NAME;


Then try executing the following:


ALTER SESSION SET EVENTS ‘30090 TRACE NAME CONTEXT FOREVER, LEVEL 32’;
exec dbms_dst.unload_secondary;


Re-execute the query:


SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE ‘DST_%’
ORDER BY PROPERTY_NAME;


****check the value of  DST_UPGRADE_STATE should be NONE

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2125797/，如需轉載，請註明出處，否則將追究法律責任。