This content has been marked as final. Show 5 replies
Can you do the change after the upgrade, like
SQL> ALTER DATABASE SET TIME_ZONE = '04:00';
even if it is not auto. switched?
Edited by: HuaMin Chen on Oct 12, 2012 12:04 PM
I don't know about it.
Select * from v$timezone_file shows 3 for 10.2.0.3 and 4 for 10.2.0.5 databases.
You can give it a try
What if this doesn't work?
I need a sure shot solution.
I cannot take risk.
Just for knowledge sharing ,
after upgradation the timezone was updated to 4.