Re: regarding the use of DB Links while using Joins in Tables

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 28 Mar 2006 08:31:07 -0800
Message-ID: <1143563467.702315.232270@i39g2000cwa.googlegroups.com>

V.Murali Dharan, your posted query which shows two tables being joined does not provide any join conditions. Lack of join conditions is normally an error.

If all the tables in a query are remote then Oracle will send the query to that remote site to be ran and return the result set to the submitting site. That is a remote query.

If the objects in a query exist at multiple databases then that is a distributed query. Oracle chooses a site to run the query on, driving site, and returns the results to the submitting site. Most often the submitting site is the driving site, but not always.

HTH -- Mark D Powell -- Received on Tue Mar 28 2006 - 10:31:07 CST