| How to change db timezone parameter. [message #473716] |
Tue, 31 August 2010 06:35  |
ashfaqhdba
Messages: 10
Registered: July 2009
|
Junior Member |
|
|
How to change db timezone parameter.
My application team has asked me to change the db timzone parameter by following sql.
ALTER database SET TIME_ZONE = '+10:00';
Is this way is the correct one , and do we have any impact on database and does it require a db bounce.
Thanks in Advance!!
|
|
|
|
| Re: How to change db timezone parameter. [message #473772 is a reply to message #473716] |
Tue, 31 August 2010 12:00  |
 |
Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Quote:Is this way is the correct one
Yes
Quote: and do we have any impact on database
All DATE and TIMESTAMP data are wrong (strictly speaking).
And you cannot do it if you have table with TIMESTAMP WITH LOCAL TIME ZONE columns:
SQL> ALTER database SET TIME_ZONE = '+10:00';
ALTER database SET TIME_ZONE = '+10:00'
*
ERROR at line 1:
ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
*Cause: An attempt was made to alter database timezone with
TIMESTAMP WITH LOCAL TIME ZONE column in the database.
*Action: Either do not alter database timezone or first drop all the
TIMESTAMP WITH LOCAL TIME ZONE columns.
Quote:does it require a db bounce
I don't think so, but test it.
Regards
Michel
[Updated on: Tue, 31 August 2010 12:01] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
