Re: Unable to set time zone

On Fri, 14 Mar 2003 19:07:11 +0100, "Michael Blaser" <miblaser_at_bluewin.ch> wrote:

>Hi folks
>
>I have a problem with the time zone on my oracle 9i release 2 server. The
>time zone isn't correct, in the documentation is written that the db takes
>the time zone from the os, which in my case is windows 2000 server. But the
>time zone is different. So I tried to change the time zone with the
>following statement:
>
>ALTER DATABASE SET TIME_ZONE = 'Europe/London';
>
>But that doesn't works at all, even exactly that statement is written in the
>documentation, I get the error:ORA-02231 missing or invalid option to ALTER
>DATABASEIn the documentation is written:Cause: An option other than ADD,
>DROP, RENAME, ARCHIVELOG, NOARCHIVELOG, MOUNT, DISMOUNT, OPEN, or CLOSE is
>specified in the statement.
>
>Action: Specify only legal options.
>
>I don't know any further . . . anybody any ideas?!?!thx Mike
>

Version? compatible parameter?
Just a few questions. My crystall ball broke centuries ago.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Mar 14 2003 - 13:02:48 CST