• This works for me

    SELECT [<column1name>]

    ,[<column2name>]

    FROM [<linked servername>]..[<oracleschemaname>].[<oracletablename>]

    GO