Re: Unix server date change

From: Frank <frankbo_at_interaccess.nl>
Date: 2000/09/21
Message-ID: <8qd2uc$lg0$1@porthos.nl.uu.net>#1/1

None of the above.

there's a special setting you want; I believe it's called fixed_date. Especially there for date (2000?) testing, and it won't affect logging, etc (anything time-related)

--
Frank
<wbuchan_at_uk.noha-systems.com> schreef in berichtnieuws
8qarou$39f$1_at_nnrp1.deja.com...


> Hi,

>

> I need to change the database date on a 8.0.6 database running on

> Solaris. This is to test some date related functionality.

>

> Is there any way to confine the date change to the database (i.e.

> for queries on SYSDATE) or do I need to change the server date (this

> could effect other things on the server not being tested)?

>

> If I do need to change the server date are there any implications for

> Oracle (eg. "randomly" moving the date back and forward by a few

> months)?  Is there any need to shutdown the instance while doing this or

> can I do it on the fly?

>

> Thanks for any help,

>

> - Bill.

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Thu Sep 21 2000 - 00:00:00 CDT