Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews.

All I want is a report of the HR or ‘blue’ stuff.

So let’s open the reports, which you’ll find on the main File menu.

Two things here to pay attention to.

First, we don’t want the main diagram in the report, that’ll give us EVERYTHING. I just want the subview diagram.

So after un-checking ‘include main diagram,’ we need to go look at the ‘Objects’ page.

We need to create a new Report Configuration.

Now we can define a reporting configuration that defines which objects we want included.

Give it a name, click on ‘subviews’, click over the subview(s) you want included, then save the configuration.

With our configuration saved and now available, we can go back and select it from the Objects panel.

Depending on how big your subview is, this could take a second or 3.

And Our Report!

Data dictionary info AND our subview diagram – all in one HTML report.

Note I generated this using 4.2.0.17 of SQL Developer. Also note I noticed there’s a bug where the Subview Diagram links in the navigation bar to the left don’t work. Thankfully the object links work for the data dictionary bits, and you can just scroll down to the diagram.

If we had included the main diagram (remember when we unchecked that box?), our report would have two diagrams instead of just the one here for the SubView.

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

6 Comments

  1. Samantha Mafla Reply

    Realicé paso a paso este tutorial, y aún asi en los diagramas se me generan todos los diagramas que tengo de todas las subvistas, quisiera saber como hacer que funcione bien en la version Oracle Data Modeler 19.2

  2. Jo Tømmerås Reply

    Hi Jeff,

    The SDDM reports are great and we would like to automate the production and embed them in our system documentation (Atlassian Confluence) by an overnight job. We have a large data warehouse model with 4000 tables and the number of reports/models is too high to make this as regular, manual task.
    So – with the reporting schema as a source for the SDDM reports – could it be possible to call the pl/sql procedure PKG_OSDM_UTILS.Generate_Report to produce the standard table reports in batch (just setting up a scheduled job producing reports from the db server)?

  3. I am using SQL Developer 4.0.0.13, the options are completely different. There is no place to uncheck “Include All Objects”. Can you please clarify how to do this for this version ?

    • Your software is quite out of date. You could upgrade faster than I could answer this question.

    • Ok, will do, but how to access it in the new version ?

Reply To Faiz Cancel Reply