How to specify the DST version when running utltz_upg_check.sql during DST upgrade? (Doc ID 2940812.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

When upgrading the DST version using utltz*.sql scripts - "utltz_upg_check.sql"- we should have provision to pass the required DST version as similar to DBMS_DST package (dbms_dst.begin_upgrade ('new DST version number')

Currently utltz_upg_check.sql detects most recent version of DST upgrade from zoneinfo and then patches data with latest version. This is automatic. Suppose, if we applied the patch DST 40, we should be able to upgrade the DST to 39 but currently @utltz_upg_check.sql picks the version 40 automatically.

This note provides the solution to pass the required DST version to utltz* script. This is helpful incase if two database running on the same oracle_home but requires different DST version for both database.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.