Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: changing system date

Re: changing system date

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Thu, 30 Jun 2005 10:16:29 +0530
Message-ID: <a144e5210506292146b9aee71@mail.gmail.com>


thanx dear,
 It worked.

 On 6/29/05, gparc_at_free.fr <gparc_at_free.fr> wrote:
>
> onkarnath,
>
> to revert your change use :
>
> SQL> alter system set fixed_date=none;
>
> HTH
>
> Selon Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>:
>
> > 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_at_yahoo.com
onkarnath.tiwary_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 30 2005 - 00:51:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US