Re: changing server time which affects oracle time

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?

I would advise you to ignore the "other party" in the future as that "party" is totally clueless.

You are correct that changing server time will change Oracle time but there is no justication for changing any time whatsoever. It is the wrong solution to your still unstated problem. Describe the problem, in detail, and Oracle version number and we will give you advice that works.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)