<p>I have a Windows 2008 Server (x64) running Microsoft SQL 2008 (x64) and I'm creating a Linked Server connection to an Oracle server.  I'm able to make the connection, but I cannot see any information regarding which schema a table belongs to.</p>

<p>In SQL 2005, my linked servers show the schema information as I would expect.</p>

<p>Does anyone know how to resolve this issue?  Is it an issue with the provider, OraOLEDB.Oracle?</p>

<p>Any help or pointers would be appreciated.</p>

[{'answer_id': 33562, 'author': 'Otto', 'author_id': 519, 'author_profile': 'https://Stackoverflow.com/users/519', 'pm_score': 2, 'selected': False, 'text': "<p>@Boojiboy - When you are looking at the tables via a linked server, there used to be a column for what schema.  It appears that in the latest the new Oracle OLEDB drivers don't show this information any longer.</p>\n"}, {'answer_id': 255917, 'author': 'Josh', 'author_id': 32963, 'author_profile': 'https://Stackoverflow.com/users/32963', 'pm_score': 1, 'selected': False, 'text': '<p>It looks like sp_tables_ex will do the trick, it came from the below article.</p>\n\n<blockquote>\n  <p>--verify tables OK exec sp_tables_ex @table_server = \'LINKED_ORA\',\n  @table_schema=\'MySchema\'</p>\n  \n  <p>@table_schema is optional.  If not\n  provided, you will get a list of all \n  tables in all schemas.</p>\n</blockquote>\n\n<p><a href="http://it.toolbox.com/blogs/daniel-at-work/linking-sql-server-2005-to-oracle-26791" rel="nofollow noreferrer">http://it.toolbox.com/blogs/daniel-at-work/linking-sql-server-2005-to-oracle-26791</a></p>\n'}, {'answer_id': 660210, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 0, 'selected': False, 'text': '<p>Also in the SQL 08 > Server Objects > Providers\nmake sure your OraOLEDB.Oracle provider is allowing inprocessing</p>\n'}]
['https://Stackoverflow.com/questions/26746', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/519/']