How to export data dictionary with Toad for Oracle

Bart Gawrych - Dataedo Team Bart Gawrych 2019-04-11

Table of Contents:


    In this tutorial I will describe how to generate Data Dictionary in Toad for Oracle.

    Open Report -> Reports Manager from Database in toolbar.

    In Reports Manager:

    1. Expand Table and Index Reports category and select Tables and Columns
    2. If you want to generate data dictionary of other users (schema) than provide schema name in other_users field in Value (Expression). If you don’t want to include current schema to data dictionary delete row me.
    3. To generate report click on Run Selected Report button.

    1. In Preview window select save icon and choose HTML file.

    Sample result:

    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.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy.
    Accept