Skip to Content
Technical Articles
Author's profile photo Jochen Rapp

Data dictionary views related to “Tables”

Oracle Data Dictionary

The challenge:

The Oracle Data Dictionary consists of hundreds of views and describes all kind of meta-data that is stored in a database.
The existing documentation from Oracle describes most of these single views.
But the challenge is always to get the full information related to an object-type like:

Table, Index, Partition, Sequence,….

Visualization in ERD-graphs:

Therefore i started to generated ERD-graphs for the most used types.
The attached example shows all data-dictionary views that are related to “Tables”.
The arrows between the views, are like foreign-keys.

The full set of available graphs is visible in:

VISKey (



Finding the adequate dictionary view to support your software development can be challenging.
Therefore  checking the available graphs is helpful to get the full picture of available views and their relation.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.