Home » RDBMS Server » Server Administration » TO MAKE THE DATABASE TIME CLICK INVARIABLE OF OS date & time
TO MAKE THE DATABASE TIME CLICK INVARIABLE OF OS date & time [message #55149] Tue, 07 January 2003 20:00 Go to next message
chandra
Messages: 31
Registered: October 2000
Member
Hi,
Is there a way to start the time on the oracle database running when you change the database date using the ALTER SYSTEM SET FIXED_DATE + 'xxxxxxxx' command. This is because there are more then one database residing on the unix server and changing the server date is not desirable as it affects other databases.

Thanks

Report message to a moderator

Re: TO MAKE THE DATABASE TIME CLICK INVARIABLE OF OS date & time [message #55156 is a reply to message #55149] Wed, 08 January 2003 03:26 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 

alter system set fixed_date = '2003-01-01-01:01:01';

the above sets a fixed date for sysdate.
we use it frequently for testing.
but it will not be regular incrementing sysdate.
I dont think we can change sysdate within database.
i beleive sysdate is hihly dependent on systemdate(OS level).

Report message to a moderator

Previous Topic: Log file sync
Next Topic: How to clear log1-10orcl.ora?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 00:39:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.