Hi,

i just got into a similar problem.

Created a linked server on my Sql Server 2008 R2, this for an instance of Oracle11.2g

After lots of troubles, finllay got to create the bloody linked server and when trying to select some data from it, sql always prompted an error like "cannot find table bla bla".

Got the trick, you have to make:

"Select * from [i]linkedserver[/i]..[i]schemaname[/i].[i]tableName[/i]"

hope it helps! 🙂