database 如何可视化 Oracle 数据库中表的关系
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1333400/
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
How to visualize the relationship of tables in an Oracle database
提问by
I know in Access there is a way I can visualize the relationship between tables in a diagram - kind of like an ER diagram.
我知道在 Access 中有一种方法可以可视化图表中表之间的关系 - 有点像 ER 图。
I am new to Oracle. I am wondering if I can do the same/similar thing with Oracle. Could someone give some suggestions?
我是 Oracle 的新手。我想知道我是否可以用 Oracle 做同样/类似的事情。有人可以给一些建议吗？
回答by Santosh Gokak
Oracle SQL Developer Data Modeler- Tool recently launched by Oracle.
Oracle SQL Developer Data Modeler- Oracle 最近推出的工具。
Schemaspyis good if you require an offline easy to navigate html report.
如果您需要易于浏览的离线 html 报告，那么Schemaspy会很好。
回答by APC
Oracle don't provide a tool for free. Their SQL Developer Modeleris pretty good but price-y if you need to buy a commercial license.
Oracle 不会免费提供工具。如果您需要购买商业许可证，他们的SQL Developer Modeler非常好，但价格昂贵。
If you are interested in platform independence then Power Architectis FOSS.
如果您对平台独立性感兴趣，那么Power Architect就是 FOSS。
回答by MAbraham1
Download Oracle Data Access Components (ODAC), which is usually packaged with Oracle Developer Tools for Visual Studio. Follow the install instructions for the Oracle ODBC driver. Add a System DSN (Start > Run > type odbcad32press ENTER).
下载 Oracle 数据访问组件 (ODAC)，它通常与 Oracle Developer Tools for Visual Studio 一起打包。按照 Oracle ODBC 驱动程序的安装说明进行操作。添加系统 DSN（开始 > 运行 > 键入odbcad32按 ENTER）。
No you can open an entity-relationship diagram through MS Access, MS Visio, Visual Studio, Enterprise Architect, or other ODBC-compliant data tools.
不，您可以通过 MS Access、MS Visio、Visual Studio、Enterprise Architect 或其他 ODBC 兼容的数据工具打开实体关系图。
For example, in MS Access: File > Open > Under "Files of type", select ODBC Databases. This selection is at the bottom of the drop-down list. Select "Database Tools" tab, then "Relationships" to view the Oracle table relationships. Here is a link to an article where Oracle provides documentation on how to visualize the relationships during a migration from Access.
例如，在 MS Access 中：文件 > 打开 > 在“文件类型”下，选择 ODBC 数据库。此选项位于下拉列表的底部。选择“数据库工具”选项卡，然后选择“关系”以查看 Oracle 表关系。这是一篇文章的链接，其中 Oracle 提供了有关如何在从 Access 迁移期间可视化关系的文档。
In MS Visio, choose FILE > NEW > "Software and Database" > "Database Model Diagram". Then select "Database" from the top menu, and "Reverse Engineer". Select the ODBC connection. If you get an error, hit escape. Continue until the diagram is loaded.
在 MS Visio 中，选择“文件”>“新建”>“软件和数据库”>“数据库模型图”。然后从顶部菜单中选择“数据库”，然后选择“逆向工程师”。选择 ODBC 连接。如果出现错误，请点击转义。继续直到加载图表。
Enterprise Architect and Visual Studio offer much better capabilities, having similar instructions.
Enterprise Architect 和 Visual Studio 提供了更好的功能，具有类似的说明。
Hope that is clear and helpful. Merry Christmas!
希望这是清楚和有帮助的。圣诞节快乐！
回答by Raj More
There is no inbuilt tool, but you can use some free ware, or even buy some of these if you really like them.
没有内置工具，但您可以使用一些免费软件，如果您真的喜欢它们，甚至可以购买其中的一些。
https://stackoverflow.com/questions/674911/light-weight-er-diagram-tool
https://stackoverflow.com/questions/674911/light-weight-er-diagram-tool
Good tool to visualise database schema?
My personal favorite is ER/Studio
我个人最喜欢的是ER/Studio
回答by zendar
Oracle Sql Developeris free and have Query builder which can display diagram. You can drag and drop tables from list of tables in schema.
Oracle Sql Developer是免费的，并且具有可以显示图表的查询生成器。您可以从架构中的表列表中拖放表。
回答by user151019
You can connect Access to Oracle via ODBC. Then display the oracle tables in access.
您可以通过 ODBC 将 Access 连接到 Oracle。然后在 access 中显示 oracle 表。
