Re: db-link 7.3.4 to 8.0.5

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/03/10
Message-ID: <38C91009.2A644F65@edcmail.cr.usgs.gov>#1/1

Terry,

I'm not sure why your database is hanging, but I have seen problems with dblinks between Oracle 7 & 8. Query hints have problems in this environment. Are you using any hints? Maybe you should include a copy of your query. That might help diagnose the problem.

HTH,
Brian

Terry Dykstra wrote:
>
> I run a query from a 7.3.4 database using db-links to a 8.0.5 database and
> it just hangs my 734 database. When I copy the 734 tables to the 805
> database and run the same query without dblinks, it returns the answer in
> less than 1 second. Anybody have any insights into this?
>
> --
> Terry Dykstra
> Canadian Forest Oil Ltd.
> Check out Sybase Developer's Network: http://www.sybase.com/sdn

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Mar 10 2000 - 00:00:00 CST