Re: changing server time which affects oracle time

From: Igor Racic <igor.racicC_at_freesurf.fr_no_C>
Date: Tue, 07 Sep 2004 20:39:17 +0200
Message-ID: <413dffbe$0$22729$626a14ce@news.free.fr>

yls177 wrote:
> hi, oracle transaction time comes from the server time? Therefore, if
> we changed the oracle time, then inherently, this will affect the
> oracle and transaction time, right? currently, we have an issue here.
> Some jobs were not run properly and we were advised by the other party
> that the only solution is to change the server time to past times, so
> as to enable the job to run. Afterwhich, we can update the time to the
> present time.
>
> Any advise?

Probably Sybrand gave you good answer.
But if you insist and know what you are doing, maybe fixed_date parameter could be of help:

   1* alter system set fixed_date='2001-01-01-11-00-00' SQL> / System altered.

SQL> select sysdate from dual;

SYSDATE

---

01-JAN-01 SQL> alter system set fixed_date=none ;

System altered.

SQL> select sysdate from dual;

SYSDATE

---

07-SEP-04 Igor Received on Tue Sep 07 2004 - 13:39:17 CDT