Re: set fixed_date to roll on?

Andrew,

Setting Oracles date into future was part of my Y2K testing so I can confirm it works and once set just carries on like normal. The Oracle instance doesn't refer back to the date on your OS except at start-up. Another way of changing your date is to change the date of the session that starts the Oracle instance before start-up. Keep in mind that this will only affect things that get there date from inside Oracle!

Hope this helps.

Fraser McCallum
MVP Oracle
www.brainbench.com

"andrew_webby at hotmail" <andrew_webby_at_hotmail.com> wrote in message news:f45d9b0.0110230525.28db3e04_at_posting.google.com...
> Sigh
>
> I'm asking this question under duress. I'm assured that it's possible
> to set the clock in an Oracle instance to a fixed date. And of course
> it is via 'alter system set fixed_date=' etc.
>
> However, I'm also 'assured' that it's possible to set it in the
> future, and have it count on from there itself - which doesn't sound
> like a 'fixed_date' to me. Frankly I can't see it, short of scheduling
> a cron or dbms_job to keep rolling the time on every few minutes.
>
> Can someone please vouch for that so I can wave it about?
>
> Thanks
>
> Andrew
Received on Tue Oct 23 2001 - 09:48:15 CDT