HELP needed w/SQL*NET V1

From: MD Automobile Insurance Fund <maif_at_charm.net>
Date: 17 Feb 1995 14:50:41 GMT
Message-ID: <3i2d41$rk8_at_canton.charm.net>

We are currently running Oracle version 6 with SQL*NET v1. I have set up a database link to a remote database. I am trying to run a query doing a join of 2 tables, both on the remote machine. Both tables are indexed by the columns being joined. I am not getting any response. I can see that the link is made and the query is running by logging into the remote machine and bringing up the SQL*DBA monitor. If I query against 1 table at a time the response is instantaneous. It seems as though the indexes are not being used on a join condition. I have also tried using a subquery and get no response.

If anyone can offer any help or has any suggestions it will be greatly appreciated. Thanks.

--

--

maif_at_charm.net MD Automobile Insurance Fund Received on Fri Feb 17 1995 - 15:50:41 CET

This message: [ Message body ]
Next message: Mr Angus Beare: "will I ever get Personal Oracle??"
Previous message: Glenn Travis: "sga and shared pool size"
Next in thread: C:DEMONSPOOLMAIL: "Re: HELP needed w/SQL*NET V1"
Reply: Roderick Manalac: "Re: HELP needed w/SQL*NET V1"
Reply: C:DEMONSPOOLMAIL: "Re: HELP needed w/SQL*NET V1"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message