Oracle 18.0.0.0 update DST to

Oracle 19c impdp 18c reported an error (, I don't remember the details of the error), but if the basic situation of hight version impdp low version is excluded, you must pay attention to the DST time zone version.

Download DSTv32

The patch for opatch applu logging is to copy the v32 time zone file to the timezone directory.

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