yls177 wrote:
> Igor Racic <igor.racicC_at_freesurf.fr_no_C> wrote in message news:<413dffbe$0$22729$626a14ce_at_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
>
>
> hi, my colleague went ahead with the operation, changed the server
> time to past time, ran the programs, changed the time back to current.
> The good thing is that oracle is able to start up though i havent
> examined the alert file for any entries.
>
> What consequences could happen?
<HARSH RANT>
Alas stupditity isn't fatal often enough. Kiss off any order by clauses
that use a timestamp. Depending on your design kiss off data integrity
for some set of records. But mostly kiss off any thoughts that you folks
have a clue how to run a production environment. You folks just went
into a production environment, without any testing, without any QA, and
made changes. You were lucky ... nothing more. If you don't learn from
common sense perhaps it will take a train wreck to bring your managment
team to its senses. Then they should fire the lot of you for gross
negligence.
</ HARSH RANT>
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Sep 07 2004 - 23:34:23 CDT
