1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. TIMEZONE_VERSION_UPGRADE_ONLINE

2.364 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.