How to visualize table relationships in an Oracle database

Question

I know there is a way in Access that I can visualize the relationship between chart tables - like an ER chart.

I am new to Oracle. I am wondering if I can do the same / similar with Oracle. Can someone give some suggestions?

Answer 1

Oracle SQL Developer Data Modeler - A tool recently launched by Oracle.

Schemaspy is good if you need a standalone simple porting of an html report.

Answer 2

Oracle does not provide a free tool. Their Developer SQL Developer Modeler is nice, but price-y if you need to buy a commercial license.

If you are interested in platform independence, then Power Architect is FOSS.

Answer 3

Download the Oracle Data Access Components (ODAC), which is usually packaged with the Oracle developer tools for Visual Studio . Follow the instructions to install the Oracle ODBC driver. Add a system DSN (Start> Run> type odbcad32 press ENTER).

No, you can open an entity relationship diagram through MS Access, MS Visio, Visual Studio, Enterprise Architect or other ODBC compatible tools.

For example, in MS Access: File> Open> In the "Files of type" section, select the ODBC database. This selection is at the bottom of the drop-down list. Click the Database Tools tab, then Relations, to view Oracle relationships. Here's a link to an article where Oracle provides documentation on how to visualize relationships during the transition from Access .

In MS Visio, select FILE> NEW> "Software and Database"> "Database Model Diagram". Then select “Database” in the top menu and “Reverse Engineer”. Select an ODBC connection. If you receive an error message, press escape. Continue to download the chart.

Enterprise Architect and Visual Studio offer much better features with similar instructions.

Hope this is understandable and helpful. Merry Christmas!

Answer 4

There is no built-in tool, but you can use some free cookware or even buy some if you really like.

https://stackoverflow.com/questions/674911/light-weight-er-diagram-tool

Good tool for visualizing database schema?

My personal favorite is ER / Studio

Answer 5

Oracle Sql Developer is free and has a query builder that can display a chart. You can drag and drop tables from the list of tables in the schema.

Answer 6

You can connect to Oracle through ODBC. Then display the oracle tables in access.