Message-Id: <10543.110804@fatcity.com> From: Jay Weinshenker Date: Thu, 29 Jun 2000 12:15:37 -0500 Subject: 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