Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: QN: Different time for separate instance?
It should be possible to have instances set to different time zones if running
under UNIX using the TZ environment variable. To do this:
1. shutdown database and quit server manager 2. setenv TZ <whatever> 3. run svrmgr again and start your instance
Ong Kian Ann wrote:
> Could I just enquire that if it is possible to set different time to
> separate Oracle Instance? Meaning that when I do a 'sysdate' from the
> instances, I get different timing from each one. I would appreciate any help
> given. Thank you and have a nice day.
>
> Ong Kian Ann
Received on Thu Jun 10 1999 - 08:28:33 CDT