Change Timezone in Oracle Database for CDB and PDB

In this blog, We are going to see how to change DBTime zone in multitenent database. Oracle recommends setting the database time zone to UTC (0:00), as no conversion of time zones will be required. CDB LevelSQL> SELECT DBTIMEZONE FROM dual;DBTIME——+00:00SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’;Database altered.SQL> SELECT dbtimezone FROM DUAL;DBTIME—— — > No change. Bounce …

Change Timezone in Oracle Database for CDB and PDB Read More »