oracle18.0.0.0updateDSTto

oracle 19c impdp 18c 报错 (哈哈 具体报错内容不记得了),但hight version impdp low version 如果报错基本情况排除后,一定要注意DST时区版本。
下载DSTv32
补丁进行opatch applu 日志就是将v32的时区文件copy到timezone目录中。

创新互联公司网站建设服务商,为中小企业提供网站制作、成都网站建设服务,网站设计,网站托管、服务器租用等一站式综合服务型公司,专业打造企业形象网站,让您在众多竞争对手中脱颖而出创新互联公司

After applying the DST patch, need to upgrade the timezone file by script. Please refer the following link.

https://docs.oracle.com/en/database/oracle/oracle-database/18/nlspg/datetime-data-types-and-time-zone-support.html#GUID-B0ACDB2E-4B49-4EB4-B4CC-9260DAE1567A

4.7 Upgrading the Time Zone File and Timestamp with Time Zone Data

In 18c, there are 2 ways, choose either of them.

Upgrading the Time Zone Data Using the utltz_* Scripts
Upgrading the Time Zone Data Using the DBMS_DST Package


文章题目:oracle18.0.0.0updateDSTto
标题网址:http://cdiso.cn/article/pidhes.html

其他资讯