Linked server to Oracle - how to query?

Question

Post reply

Linked server to Oracle - how to query?

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mike01 SSChampion Points: 11420 More actions · Answer 1

Have you tried using OpenQuery instead?

Select * from OpenQuery(MyLinkedServer,'Select * from MySchema.MyTable')

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Garadin One Orange Chip Points: 29613 More actions · Answer 2

Does oracle handle schemas the same way as MS SQL? (Totally clueless about all things oracle)

The other option to try might be:

select * from myLinkedServer...[mySchema.myTable]

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Mike01 SSChampion Points: 11420 More actions · Answer 3

Garadin (4/29/2010)
Does oracle handle schemas the same way as MS SQL? (Totally clueless about all things oracle)
The other option to try might be:
select * from myLinkedServer...[mySchema.myTable]

I don't remember, but I think it doesn't use the 4 part naming convention like SQL nor does it need the brackets. I think it would be more like

select * from myLinkedServer.mySchema.myTable

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/