Hi masters!!! It's my first time here. Please, forgive my poor knowledge.
I've got a working linked Server with Oracle, but one problem:
When I execute a count query it gives me the right answer, but, when I execute a simple select to retrieve the data, it gives me just a part of my count.
SELECT * FROM OPENQUERY(myserver,'SELECT COUNT(*) FROM mytable') ==> This count returns 349, that is the number of lines in my table.
SELECT * FROM OPENQUERY(myserver,'SELECT * FROM mytable') ==> This select returns only 250 lines, that is a part of my table.
Please, can you help me with this scenario?
It would have the same result (349 lines instead of 250).
Thank you so very much (in advance)...