My Oracle Support Banner

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:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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