How to export data dictionary with Oracle SQL Developer

Oracle SQL Developer is a free development tool for Oracle database. It has a nice feature of generating data dictionary and exporting it to HTML.

To generate data dictionary create connection to your database, then select connection, right click and choose Generate DB Doc....

Then choose output directory and optionally take time to select database object types.

Click OK and wait for export to complete. This is how it looks:

You can use it locally or post on web server.

See sample export

An alternative: Dataedo

If you want more from the data dictionary export, have a look at Dataedo. Not only it generates much better looking and interactive HTML but also allows you to visualize schema with ER diagrams, split large database into modules, describe each data element and document table relationships. Here is a sample documentation:

See live sample

Try it yourself for free now

0
There are no comments. Click here to write the first comment.