文档解释
ORA-56936: datapump jobs are utilizing secondary time zone data file
Cause: An on-demand loading of secondary time zone data file was requested when there was a secondary time zone data file already loaded in the database utilized by existing datapump jobs.
Action: Wait until existing datapump jobs unload the secondary time zone data file.
。
ORA-56936错误消息为：Data Pump jobs are utilizing secondary time zone data file。
官方解释
常见案例
一般处理方法及步骤
1.使用ALTER SESSION命令更改当前session的时区：
ALTER SESSION SET TIME_ZONE = {time_zone};
例：ALTER SESSION SET TIME_ZONE = ‘America/Atikokan’；
2.更新dbs Date File
ALTER DATABASE{db_name} SET TIME_ZONE='{time_zone}’；
例：ALTER DATABASE MyDB SET TIME_ZONE=’America/Atikokan’
3.使用Data Pump导出数据
expdp {username/password} {directory_object= dir_name} FULL=Y
例：expdp system/password DIRECTORY= data_pump_dir FULL=Y
