Oracle Linked Server

Does anyone have any experience with Oracle linked servers? We are
considering using an Oracle linked server to pull data out of an Oracle
database into a SQL Server application but our understanding is that a
query's where clause issued from SQL server to Oracle is not resoved until
the entire contents of the Oracle table is brought back to SQL server. Should
Oracle linked servers be generally avoided from within a SQL Server OLTP
application?No...not necessarily. In addition, you can use Openquery
with the linked server. You just need to write the query
using PL/SQL syntax and not T-SQL syntax. But an openquery
will pass the query string to Oracle and the string you
passed will be executed on the Oracle box and the results
returned to SQL Server. Sometimes referred to as a
pass-through query.
-Sue
On Mon, 28 Feb 2005 08:57:02 -0800, "Ray Kurpiel"
<RayKurpiel@.discussions.microsoft.com> wrote:
>Does anyone have any experience with Oracle linked servers? We are
>considering using an Oracle linked server to pull data out of an Oracle
>database into a SQL Server application but our understanding is that a
>query's where clause issued from SQL server to Oracle is not resoved until
>the entire contents of the Oracle table is brought back to SQL server. Should
>Oracle linked servers be generally avoided from within a SQL Server OLTP
>application?