如何修改PDB的db time_zone以及session 的time_zone

修改PDB的时区

SQL> show con_name;
CON_NAME
------------------------------
CDB2PDB21048
SQL> show con_id;
CON_ID
------------------------------
46
SQL> select dbtimezone from dual;
DBTIME
------
+09:00
SQL> alter database set time_zone='-04:00';
Database altered.
SQL> alter pluggable database close immediate instances=all;
Pluggable database altered.
SQL> alter pluggable database open read write instances=all;
Pluggable database altered.
SQL> select dbtimezone from dual;
DBTIME
------
-04:00

修改session的时区

SQL> select sessiontimezone from dual;
SESSIONTIMEZONE
---------------------------------------------------------------------------
+00:00
SQL> select dbtimezone from dual;
DBTIME
------
-04:00
SQL> alter session set time_zone='+11:00';
Session altered.
SQL> select sessiontimezone from dual;
SESSIONTIMEZONE
---------------------------------------------------------------------------
+11:00

https://blog.csdn.net/u011316319/article/details/9277055

https://blog.csdn.net/w892824196/article/details/98625695