Shows the usage of Logical DataTypes within Oracle Data Modeler:

  1. You’ll need a Database (any Database that supports a JDBC driver should work). I used Oracle XE.
  2. Choose Export to Reporting Schema: File Export Report Schema Setup acess to the database as required. When the export is complete. You’ll have a complete copy of your Design’s Metadata in the choosen database.
  3. Login to you database, and run the following query:

     select
       LT_NAME, count(LOGICAL_TYPE_NAME) Total
     from
         DMRS_ATTRIBUTES right outer join DMRS_LOGICAL_TYPES ON DMRS_ATTRIBUTES.LOGICAL_TYPE_NAME = DMRS_LOGICAL_TYPES.LT_NAME
     group by
       LT_NAME
     order by
       Total desc;
    

    This will return the list of the Logical Types names and their usage amounts.