Re: Problem with Oracle Timezones

From: Tejaswini <tejaswini.dixit_at_gmail.com>
Date: 20 Apr 2005 03:14:49 -0700
Message-ID: <1113992089.479230.307110@l41g2000cwc.googlegroups.com>

Hi,

Thanks for response,

I figured out that the problem may be due to difference in Oracle versions of client and server.

The client is using 9.2.0.1 version and server uses 9.2.0.6. version.
>From version 9.2.0.5, default time zone file used is
$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat if ORA_TZFILE parameter is not set (ref : Oracle Document (Doc ID 282992.1)). For lower versions, it is $ORACLE_HOME/oracore/zoneinfo/timezone.dat.

Thus server supports more time zone values than client and hence the error.

Thanks & Regards,
Tejaswini Received on Wed Apr 20 2005 - 05:14:49 CDT