从 Oracle 数据库反向工程数据库
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3474107/
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
Reverse engineer database from an Oracle database
提问by Julio Guerra
I would like to know if there is any tool able to extract the design from an existing Oracle database.
我想知道是否有任何工具能够从现有的 Oracle 数据库中提取设计。
I have a read access to it and I would like to have the design. Or simply export it to a *.sql and then read it with any tool able to create the design with the links between the tables.
Something like that 
(source: fileguru.com)
我有阅读权限，我想要设计。或者简单地将其导出为 *.sql，然后使用任何能够使用表之间的链接创建设计的工具读取它。类似的东西（来源：fileguru.com）
Thank you very much.
非常感谢。
回答by APC
There are a number of tools which do reverse engineering from an Oracle database, but most require a license.
有许多工具可以从 Oracle 数据库进行逆向工程，但大多数都需要许可证。
Oracle has its own Data Modeller. Previously Oracle tried to charge an exorbitant licence fee but obviously they had few takers because it is now free. It is not a great product but it does a decent job on reverse engineering.
Oracle 有自己的数据建模器。以前甲骨文试图收取过高的许可费，但显然他们很少有人接受，因为现在是免费的。它不是一个伟大的产品，但它在逆向工程方面做得不错。
If you are a site which uses TOAD then you should definitely consider Quest's TOAD Data Modeler. The additional cost is not a great stretch from the basic TOAD fee.
如果您是使用 TOAD 的站点，那么您绝对应该考虑使用Quest 的 TOAD Data Modeler。额外费用与基本 TOAD 费用相差不大。
There are not many other free tools left on the market but SQL Power offer a community edition of their SQL Architect tool which does reverse engineering. Check it out.
市场上没有多少其他免费工具，但 SQL Power 提供了他们的 SQL Architect 工具的社区版，可以进行逆向工程。 检查一下。
回答by Julio Guerra
Oracle SQL Data Modeler answered to all my questions.
Oracle SQL Data Modeler 回答了我的所有问题。
It has a reverse engineering tool that creates the logical and physical model from the database.
它有一个逆向工程工具，可以从数据库创建逻辑和物理模型。
