View with a query to an oracle database

[A.M. de Jong]

Hi,

In our environment a database view is based on columns in a table from an
oracle database.
This is a linked server I believe.
I am told that since we use this construction no where clause is possible.
So we get to many rows in our database which we have to filter later on.

How can we do this differently ?? Since it takes a lot of time to go through
this process.

Bye,

Arno de Jong, The Netherlands.

[Lyndon Hills]

Re: View with a query to an oracle database

On Fri, 14 Nov 2003 09:15:56 +0100, "A.M. de Jong" <arnojo@wxs.n l>
wrote:
[color=blue]
>Hi,
>
>In our environment a database view is based on columns in a table from an
>oracle database.
>This is a linked server I believe.
>I am told that since we use this construction no where clause is possible.
>So we get to many rows in our database which we have to filter later on.
>
>How can we do this differently ?? Since it takes a lot of time to go through
>this process.
>
>Bye,
>
>Arno de Jong, The Netherlands.
>
>[/color]
Can't you create the view in Oracle?

[Daniel Morgan]

Re: View with a query to an oracle database

Lyndon Hills wrote:
[color=blue]
> On Fri, 14 Nov 2003 09:15:56 +0100, "A.M. de Jong" <arnojo@wxs.n l>
> wrote:
>
>[color=green]
>>Hi,
>>
>>In our environment a database view is based on columns in a table from an
>>oracle database.
>>This is a linked server I believe.
>>I am told that since we use this construction no where clause is possible.
>>So we get to many rows in our database which we have to filter later on.
>>
>>How can we do this differently ?? Since it takes a lot of time to go through
>>this process.
>>
>>Bye,
>>
>>Arno de Jong, The Netherlands.
>>
>>[/color]
>
> Can't you create the view in Oracle?[/color]

From what was posted it is impossible to tell what is really going on.
But it seems highly unlikely one could link SQL Server with Oracle and
not able to put a WHERE clause anywhere one wishes. Sounds to me more
like a question of the syntax being used.

--
Daniel Morgan

http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp

http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

damorgan@x.wash ington.edu
(replace 'x' with a 'u' to reply)