[quoted text, click to view]


Does Oracle have a limit on the amount of data to return in a given query?
A max rows, or max bytes?

I'm just guessing here.

When you created the linked server, what did you specify as the Collation
Compatible?

What query did you run? If it was ANSI then you should get the same number
of rows back, if you used T-SQL commands, then you may not get quite what
you expected. Outer joins in Oracle are done differently than outer joins
in T-SQL.

HTH

Rick

When i execute a Query from an Oracle Linked server i got 99 rows less then
the original data.

when i run The query in oracle i got 999 rows , when i run in SQL using
openquery i got 900 rows.

Any idea..?