RE: database links...
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <shrekdba@xxxxxxxxx>, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Feb 2005 15:08:57 -0500
Bill,
Not sure if this is the same, although the way you get the error
is. But I was getting date format errors, time_zone undefined, when
doing the same select. Adding :
ALTER SESSION SET TIME_ZONE =3D '-04:00';
To login.sql fixed the problem. EST is GMT-4.=20
-----Original Message-----
From: Shrek [mailto:shrekdba@xxxxxxxxx]=20
Sent: Thursday, February 24, 2005 2:47 PM
To: Oracle-L (E-mail)
Subject: database links...
we have links between 9.2.0.4 and 8.1.7.4 databases that are working
fine. if, however we go to 9.2.0.5 we can select accross the link but
on a commit we get a contex incorrect error.
anybody seen this before? know a workarround?
thanks.
--=20
--
Bill "Shrek" Thater ORACLE DBA =20
shrekdba@xxxxxxxxx=20
------------------------------------------------------------------------
I am my beloved's, and my beloved is mine (Song of
Solomon 6:3)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
