Try Alter System session set time_zone = ..... ;



-----Original Message-----
From: Aneel Fazwani
[mailto:oracledba-ezmlmshield-x26315621.[Email address protected]
Sent: Monday, July 02, 2007 12:53 PM
To: LazyDBA Discussion
Subject: ORA-01882

Hi all,

I'm trying to execute a query on a DB using a connection. I created a
DB-LINK on the DB. executing the select:

select sysdate from [Email Address Removed] get the following error:

Error starting at line 1 in command:
select sysdate from [Email Address Removed] at Command Line:1 Column:19
Error report:
SQL Error: ORA-01882: timezone region not found
ORA-02063: preceding line from lnk_db_prod



The problem gets resolved when I try



alter session set time_zone ='+05:00';



but this gets resolved only for the current session. How to rectify this
for
all sessions.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page