ORA-56935: existing datapump jobs are using a different version of time zone data file

Master table "SYS"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
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


The errors are caused by the fact that a previous DataPump import job exited ungracefully, without cleaning up DST_UPGRADE_STATE due to secondary timezone table.
The errors could be also introduced after multiple import jobs were running and changed the data in the secondary timezone table.

This can be checked with the following query:

connect / as sysdba

set pages 50 lines 250
col property_name for a30
col value for a20
SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value
FROM   DATABASE_PROPERTIES
WHERE  PROPERTY_NAME LIKE 'DST_%'
ORDER  BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ --------------------
DST_PRIMARY_TT_VERSION         26
DST_SECONDARY_TT_VERSION       14
DST_UPGRADE_STATE              DATAPUMP(1)



connect / as sysdba
ALTER SESSION SET EVENTS '30090 TRACE NAME CONTEXT FOREVER, LEVEL 32';
exec dbms_dst.unload_secondary;

Session altered.

PL/SQL procedure successfully completed.

CHECK DST_UPGRADE_STATE:

SQL> set pages 50 lines 250
col property_name for a30
col value for a20
SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value
FROM   DATABASE_PROPERTIES
WHERE  PROPERTY_NAME LIKE 'DST_%'
ORDER  BY PROPERTY_NAME;SQL> SQL> SQL>   2    3    4

PROPERTY_NAME                  VALUE
------------------------------ --------------------
DST_PRIMARY_TT_VERSION         26
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE