Had no troubles with ora oledb so far. Selecting 10000 rows works fine. Perhaps a mismatch in "case" with the CaSe sensiTive Oracle?

I still need to test against some linked servertroublemakers as "metadata changed" when no precision/scale is specified for an oracle number.