Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to set time zone
"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> schrieb im Newsbeitrag
news:np947vg1tdsjq6ive8qrrstjmu7bgqit4s_at_4ax.com...
> 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
Sorry . . . forgot to mention . . . Oracle 9i Release 2 (9.2.0.1) Enterprise Edition for Windows NT/2000/XP.
thx Mike Received on Fri Mar 14 2003 - 13:39:19 CST