Re: changing system date
- From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- To: "gparc@xxxxxxx" <gparc@xxxxxxx>
- Date: Thu, 30 Jun 2005 10:16:29 +0530
thanx dear,
It worked.
On 6/29/05, gparc@xxxxxxx <gparc@xxxxxxx> wrote:
>
> onkarnath,
>
> to revert your change use :
>
> SQL> alter system set fixed_date=none;
>
> HTH
>
> Selon Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>:
>
> > hi all,
> > I had got one mail from the group wherein following command was given:
> > alter session set nls_date_format='dd.mon.yyyy hh24:mi';
> > alter system set fixed_date='<anydate>';
> > this was used to change the server date and time without affecting the
> > original date n time on the server but when I tried the command on the
> > server(test obviously not the production one) then the date n time was
> > changed and then it wasnt changing to its original value. So I had to
> > re-start the oracle database. Why so?? any idea??? Is there any method
> using
> > which we can revert it to the original value???
> > Plz. suggest
>
>
>
>
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
Other related posts:
