ORA-56936: datapump jobs are utilizing secondary time zone data file ORACLE 报错 故障修复 远程处理
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
相关文章
- ORA-00972: identifier is too long ORACLE 报错 故障修复 远程处理
- ORA-01156: recovery or flashback in progress may need access to files ORACLE 报错 故障修复 远程处理
- ORA-01272: REUSE only allowed when a file name is provided. ORACLE 报错 故障修复 远程处理
- ORA-19626: backup set type is string – can not be processed by this conversation ORACLE 报错 故障修复 远程处理
- ORA-23363: mismatch of mview base table “string” at master and mview site ORACLE 报错 故障修复 远程处理
- ORA-28392: invalid close wallet syntax ORACLE 报错 故障修复 远程处理
- ORA-31613: Master process string failed during startup. ORACLE 报错 故障修复 远程处理
- ORA-32416: one or more commit SCN-based materialized view logs are not in consistent state for fast refresh ORACLE 报错 故障修复 远程处理
- ORA-39178: cannot perform estimate on metadata only jobs ORACLE 报错 故障修复 远程处理
- ORA-42018: partition cannot be redefined online because of index organization incompatibility ORACLE 报错 故障修复 远程处理
- ORA-00378: buffer pools cannot be created as specified ORACLE 报错 故障修复 远程处理
- ORA-06923: CMX: illegal break condition ORACLE 报错 故障修复 远程处理
- ORA-07713: sksamtd: could not mount archival device (SYS$MOUNT failure) ORACLE 报错 故障修复 远程处理
- ORA-12434: invalid audit type: string ORACLE 报错 故障修复 远程处理
- ORA-12713: Character data loss in NCHAR/CHAR conversion ORACLE 报错 故障修复 远程处理
- ORA-13270: OCI error string ORACLE 报错 故障修复 远程处理
- ORA-16816: incorrect database role ORACLE 报错 故障修复 远程处理
- 1. Oracle:掌握数据库世界领域最佳解决方案(oracle加序号)
- 内数据 挖掘Oracle一个月内的宝藏:使用查询技术(oracle查询一个月)
- Optimizing Oracle Concurrent Connections(oracle并发连接)
- 深入探究Oracle语句的统计分析技巧(oracle语句统计)
- 查询解锁Oracle多条件In查询的机密(oracle多条件in)
- 简单高效!学习Oracle无参存储过程的最佳实践!(oracle无参存储过程)
- 实践掌握Oracle数据库知识!(oracle 数据库实验)
- Oracle 自动统计关闭之路(oracle关闭自动统计)
- 一文详解Oracle数据库的exp备份工具(oracle数据库exp)
- Oracle数据库中全局变量的定义(oracle全局变量定义)
- 索引Oracle SYSB索引极大提升查询性能的神奇武器(oracle SYS_B)
- Oracle数据库突破极限零起点极速成长(oracle max 0)
- Oracle 4091改变企业数据库管理的新技术(oracle 4091)