FIXED_DATE parameter and incrementing time...

Heya.

For reasons better left unexplained, I have a server which runs at the real time (6/29/2000), but I have one database which I need to run as if it's 1999 (sounds like a Prince song). Anyhow, I know I can use the FIXED_DATE init.ora/alter system parameter to change the database's timedate to a specific date time down to the second.

HOWEVER, this timestamp won't increment. IE, It will stay the exact same time all day... this is the problem I am trying to work around. I would like for the date part of the clock to stay at whatever date I set it, but I want the time to increment normally...

Anyone have any tips/ideas on doing this? The database resides on Solaris, so I'm currently considering looking at writing a daemon which will connect to the database and issue alter system set fixed_date = .... commands each second, but this is a really ugly and inefficient solution, so I'm hoping someone has something better...

Thanks in advance..

J

p.s. Yes, I thought about using a cron job, but cron's granularity is down Received on Thu Jun 29 2000 - 12:15:37 CDT