2.366 TIMEZONE_VERSION_UPGRADE_ONLINE

TIMEZONE_VERSION_UPGRADE_ONLINE enables you to keep the database running in normal mode while upgrading time zone data using the DBMS_DST package.

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	ALTER SYSTEM
Modifiable in a PDB	Yes
Range of values	true | false
Basic	No
Oracle RAC	Multiple instances must have the same value.

In releases prior to Oracle Database 21c, you were required to put the database in UPGRADE mode in order to initiate a time zone data upgrade using the DBMS_DST package. Starting with Oracle Database 21c, you can perform such an upgrade while the database is in normal mode by setting the value of TIMEZONE_VERSION_UPGRADE_ONLINE to true.

Note:

Setting the value of this parameter is only one step in a series of steps for upgrading your time zone data. Refer to Oracle Database Globalization Support Guide for the complete set of steps before you set this parameter value.