oracle VS 2010 Server Explorer 数据库不显示表
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2745151/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
VS 2010 Server Explorer Database Showing No Tables
提问by Andy
I'm working on a .Net application that needs to read from an Oracle 10g database behind Siebel. In VS 2010 Server Explorer, I've created a connection using the OracleClient type connector with a reference to the Oracle TNS service name as the "server name." The "Test Connection" button shows that the connection is successful. However, in the Server Explorer, when I go to expand the Tables, no tables are shown. I know for a fact that there are 3000+ tables in the database (thanks Siebel). Anyone know what's happening here? I'd like to create an Entity Framework 4.0 Entity Data Model...
我正在开发一个 .Net 应用程序，它需要从 Siebel 后面的 Oracle 10g 数据库中读取数据。在 VS 2010 Server Explorer 中，我使用 OracleClient 类型连接器创建了一个连接，并将 Oracle TNS 服务名称作为“服务器名称”进行引用。“测试连接”按钮显示连接成功。但是，在服务器资源管理器中，当我展开表格时，没有显示任何表格。我知道数据库中有 3000 多个表（感谢 Siebel）。有谁知道这里发生了什么？我想创建一个实体框架 4.0 实体数据模型...
Thanks for the help!
谢谢您的帮助！
Andy
安迪
回答by Steve G.
I've had the hardest time trying to solve this issue myself. There's very little useful documentation on the subject. Once you create a data connection and tested the connection click "Ok" then open up the server explorer window. Right click on the new oracle data connection and select "Change View". By default "My Objects" are selected, try selecting "User Objects" or "All Objects". Once you do, you should be able to see all of the objects under the data connection sub categories.
我在尝试自己解决这个问题时遇到了最困难的时刻。关于这个主题的有用文档很少。创建数据连接并测试连接后，单击“确定”，然后打开服务器资源管理器窗口。右键单击新的 oracle 数据连接并选择“更改视图”。默认选择“我的对象”，尝试选择“用户对象”或“所有对象”。完成后，您应该能够看到数据连接子类别下的所有对象。
回答by Siva Kandaraj
Right click on connections, go to Filters, the "displayed schemas" property by default, it's your logon name to the connection. Change the schemas to dbo schema and update the property. Then you should see all the tables. It worked for me :)
右键单击连接，转到过滤器，默认情况下“显示模式”属性，它是您连接的登录名。将架构更改为 dbo 架构并更新属性。然后你应该看到所有的表。它对我有用:)
回答by DCookie
Do you have privileges on the schema and/or tables?
您对架构和/或表有权限吗？
Don't know VS2010 but it sounds to me like there's a setting to show you only your schema by default.
不知道 VS2010，但在我看来，默认情况下有一个设置可以只显示您的架构。
UPDATE: Oracle just announced a new ODAC version, 11.2.0.1.1 Betawith support for VS 2010. You might give that a shot.
更新：Oracle 刚刚宣布了一个新的ODAC 版本，11.2.0.1.1 Beta，支持 VS 2010。你可以试一试。
回答by peroija
The same situation occurred for me, however this was with SQL Server 2008. Somehow the sql user account I was connecting with lost both read and write privileges. Once the account was given back those privileges I was able to access everything as expected.
我也遇到了同样的情况，但这是 SQL Server 2008。不知何故，我连接的 sql 用户帐户丢失了读写权限。一旦帐户获得了这些权限，我就可以按预期访问所有内容。
