Upgrading the Time Zone File Version After Upgrading Oracle Database
If the Pre-Upgrade Information Tool instructs you to upgrade the time zone files after completing the database upgrade, then use the DBMS_DST
PL/SQL package to upgrade the time zone file.
Oracle Database supplies multiple versions of time zone files. There are two types of files associated with each time zone file: a large file, which contains all the time zones defined in the database, and a small file, which contains only the most commonly used time zones. The large versions are designated as timezlrg_version_number.dat
. The small versions are designated as timezone_version_number.dat
. The files are located in the oracore/zoneinfo
subdirectory under the Oracle Database home directory.