Oracle Data Modeler Get Logical DataType Usage

Shows the usage of Logical DataTypes within Oracle Data Modeler:

You’ll need a Database (any Database that supports a JDBC driver should work). I used Oracle XE.
Choose Export to Reporting 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.

 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.

Last modified on 2016-04-27