New answers tagged server
0
Oracle object names are all uppercase by default. The linked-server query must exactly match the case of all referenced Oracle metadata, such as schema and table names.
0
If you need an Oracle proxy server, then you should investigate Oracle Connection Manager, which is exactly that.
See http://docs.oracle.com/cd/B28359_01/network.111/b28316/cman.htm for the documentation on 11gR1's version of it.
Top 50 recent answers are included
